Top 10 values

[Anonymous]

How to find top 10 items ignoring duplicate from data using DAX function in power bi?

[v-xiaotang]

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.

[amitchandak · Accepted solution]

@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-...
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/