Forum Discussion
Top Three (Text)
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.
2 Replies
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.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.
