Forum Discussion
Top 10 values
- 4 years ago
Anonymous , You can use TOPN Function on measure and plot it with items
example
Top1 total= CALCULATE([Total],TOPN(10,allselected(Table[Item]),[Total] ,DESC),VALUES(Table[Item]))
If the values are duplicate then you can try rank tie breaker
Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
Anonymous , You can use TOPN Function on measure and plot it with items
example
Top1 total= CALCULATE([Total],TOPN(10,allselected(Table[Item]),[Total] ,DESC),VALUES(Table[Item]))
If the values are duplicate then you can try rank tie breaker
Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/