Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, everyone!
I am organizing the net sales of different companies and I am trying to summarize the results in 2 cards: one with the company with the highest sales and the other with the 10th company with the highest sales.
I managed to do the first one, but I can't find a way to do the other. Could you please help?
Thanks!!
Solved! Go to Solution.
Create rank and filter on 10th Rank
https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491
Create rank and filter on 10th Rank
https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |