Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |