Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ChristianE
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
Nathaniel_C
Community Champion
Community Champion

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!




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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors