cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Correlation between values in table

Hi

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)

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Correlation between values in table

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Frequent Visitor

Re: Correlation between values in table

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?

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.