Forum Discussion
maurcoll
2 years agoHelper IV
Ranking in a table visual using a measure
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.
1 Reply
- lbendlinSuper User
Here's a good article to get you started. Use of RANKX in Power BI measures - SQLBI