Top Three (Text)

[samnaw]

Hello:

I have a pivot table in my dashboard like this:

* there are like 24 stores. 

store_name	Share Of Sale
Store 1	45.34%
Store 2	41.45%
Store 3	37.22%
Store 4	35.62%
Store 5	34.73%

I would like a DAX formula that would output me only the "Top 3 Store" based on Share of Sales. Share of Sales is already a DAX formula (i.e Subscription Sales/Total Sales)

The output should look like this:

Rank	store_name
1	Store 1
2	Store 2
3	Store 3

Not sure how to go about doing this. 

[Mikelytics]

Hi @samnaw 

another option with measure would be this:

RANK | Rank of Item = 
RANKX(
    ALL(Dim_Product),
    [Aggregation | Sum]
)

After putting the table in the visual you can sort the column with 1,2,3

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.

[Mikelytics]

Hi @samnaw 

Do you want a measure is the following approach also fine? Has the advantages that you dont need additional measures.

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.