Earn 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
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |