Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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)
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
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?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |