topic Re: RankX Ranking same values as same rank in DAX Commands and Tips

RankX Ranking same values as same rank

Anonymous — Wed, 07 Dec 2022 17:14:00 GMT

Good Day,

I am getting duplicate rankings when they have the same value. In this case its zeros. Is there a way to get it to represent 1,2 and 3 instead of 1,1,1?

Pro Audit Rank =

RANKX(ALL(System_Users),Audit[SUM Pro Audit])

Re: RankX Ranking same values as same rank

Greg_Deckler — Wed, 07 Dec 2022 17:21:30 GMT

Anonymous This can do that: The Mythical DAX Index - Microsoft Power BI Community

Re: RankX Ranking same values as same rank

Anonymous — Wed, 07 Dec 2022 17:31:40 GMT

Hey Greg_Deckler, do you think you could show me how to implement that?

Re: RankX Ranking same values as same rank

Greg_Deckler — Wed, 07 Dec 2022 18:40:12 GMT

Anonymous Post some sample data and sure.