Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Morning
I have a table that i need to rank based on the measure for % of sales
Store | % of Sales |
A | 21% |
B | 15% |
C | 35% |
D | 25% |
E | 6% |
The % is calculated as a measure dividing store sales by the total sales
I want to be able to add a column into the above table to show ranking for each store or a row number. I also need to be able to show the ranking if the number of stores changes. for example i have stores A - C filtered i want to see the ranking for just these 3 stores. In my data i sort the table by % highest to lowest.
Here's a good article to get you started. Use of RANKX in Power BI measures - SQLBI