Forum Discussion
Top 10 values
How to find top 10 items ignoring duplicate from data using DAX 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/
2 Replies
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/Hi Anonymous
I think there are two ways to do this, one you can try amitchandak's suggestion, use the topn function to determine if it's the top ten. Second, you can use scope to filter. That is, first calculate the range of the top ten, get the starting value, and then filter.
If you need more help, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
