ValueList and $Field Friendship problem (need to make correl matrix)

[ikarimov]

Hello!

I need help to build correct dynamic measure, maybe some idea? how make it work and calculate correct numbers.

data: https://gist.github.com/pranaydave/8b9453d354d67afae834e3d12be8c5fe#file-cars_data-csv

model in body )

[ikarimov · Accepted solution]

hi again i decided it myself

measure = $(=Variable1) = =concat(
'if($Field='&
chr(39)
&$Field&
chr(39)
&',correl(['
&$Field&
'],['
&valuelist($(=concat(''&chr(39)&$Field&chr(39),',')))
&']))*if(valuelist('
&Variable2
&')='
&chr(39)&valuelist($(=concat(''&chr(39)&$Field&chr(39),',')))&chr(39)
&',1,null())','&')

Variable2 =concat(chr(39)&$Field&chr(39),',')

dimension1 = $Field1

dimension2 =valuelist($(=concat(''&chr(39)&$Field&chr(39),',')))