Getting same rank for duplicates

[Sathvik123]

Hello All,

I have a report where I am taking top 10 category completed tickets for  last 12 months.

I took category and tickets completed.

To filter top 10 completed tickets for category I did like below.

But my issue is if different categories having same values also its giving as same rank.

So in my case I need to get categories till

ZCitrix.Apps Missing

only, But getting morethan that

Please suggest how to do

[amitchandak · Accepted solution]

@Sathvik123 , Create a rank with tie breaker and filter that

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/