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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 🙂
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!