Forum Discussion
Getting same rank for duplicates
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
Anonymous , 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-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/
1 Reply
Anonymous , 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-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/