topic Re: Correlation between values in table in DAX Commands and Tips

Correlation between values in table

ChristianE — Mon, 04 Nov 2019 14:10:37 GMT

I have a table with articles from different producents which fit on different cars

Example:

Part Producer Car

1 a 1

1 a 2

1 a 3

3 b 2

3 b 3

3 b 4

(IE Part 1 from Producent a fits on car 1-2-3, and Part 3 from Producent b fits on car 2-3-4)
Im trying to create a measure which shows the correlation between the Articles on cars in my table, and show the ones with the highest fit

For example the above would show

Part Producer Fit

1 1 (3,b 2/3)

Re: Correlation between values in table

Nathaniel_C — Mon, 04 Nov 2019 15:40:43 GMT

Hi ChristianE ,
Not sure if I understand your expected result. How does a producer get a 1, when the only values are alpha. Is this a count? Also please explain (3,b 2/3).
Thank you,

Nathaniel

Re: Correlation between values in table

ChristianE — Tue, 05 Nov 2019 06:29:20 GMT

Sorry after i wrote the example out i changed producers from numbers to letters try to make it more understandable, but it appears i missed the one in the result. It should be:

Part Producer Fit

1 a (3,b 2/3)

Meaning part 1, from producer a, is like part 3 from producer b, in 2 out of 3 cases (where the three is the number of possible fits for part 1). Does that make sense?