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.
Imagine a scenario:
As is shown in the capture , I have a list of color. My goal is show in a card the name of the color with major number of times that appear in the table and if I filter the result for example, selecting jacket, the color change or not depending the quantity of jackets for each color showing the name of the color color. (I don't know if I'm explaining clear sorry)
I don't know how to do this measure, I'm really lost with that.
Thanks in advance
Solved! Go to Solution.
you could achieve something like this by ussing SUMMARIZE/GROUPBY for colours, and then RANKX/TOPN
you could achieve something like this by ussing SUMMARIZE/GROUPBY for colours, and then RANKX/TOPN
Thanks for your help.
No needed measure , TopN = 1 in the Filter levels was enought 🙂
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |