Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 🙂
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 133 | |
| 88 | |
| 85 | |
| 68 | |
| 64 |