Forum Discussion
dgdgdg122db
Helper II
Helper IIRank negative number result not expected
I am trying to rank the customers based on the margins, however, I am facing issues with the ranking results, in particular, the unexpected ranks on negative numbers. Without using tie Dens...
Hi dgdgdg122db
If RRANKX with Dense fixes the issue why not just use that?
Please see the RANKX function description that explains how the Dense below.
https://docs.microsoft.com/en-us/dax/rankx-function-dax
If you want to know why it accrues you will need to investigate your Model, 'Customer EMEA ' is probably a good start.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz
Community Champion
Community ChampionHi dgdgdg122db
If RRANKX with Dense fixes the issue why not just use that?
Please see the RANKX function description that explains how the Dense below.
https://docs.microsoft.com/en-us/dax/rankx-function-dax
If you want to know why it accrues you will need to investigate your Model, 'Customer EMEA ' is probably a good start.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Mariusz
If this post helps, then please consider Accepting it as the solution.