Ranking in a table visual using a measure

[maurcoll]

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.

[lbendlin]

Here's a good article to get you started. Use of RANKX in Power BI measures - SQLBI