Forum Discussion
RANKX DENSE functionality
HI Anonymous ,
You need to break the RANK TIES.
https://docs.microsoft.com/en-us/dax/rankx-function-dax
The functionality of dense is
Dense The next rank value, after a tie, is the next rank value. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 12.
You will need a rank breaker.
Use RAND
RANKING = RANKX(ALLSELECTED('MyDataTablev 1'[Product EAN],'MyDataTablev 1'[language]),[PRODUCTSCAN] + RAND(),,DESC,dense)
else
RANKING = RANKX(FILTER(ALLSELECTED('MyDataTablev 1'[language] = MAX('MyDataTablev 1'[language])),[PRODUCTSCAN] ,,DESC,dense)
Else please share some sample data and the expected output
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi Anonymous ,
The Dense argument will return the same rank number 3 instead of 4 if the ranked values are the same. For the next rank value, after a tie, is the next rank value. For example if five (5) values are tied with a rank of 11, then the next value will receive a rank of 12. See more about RANKX function here https://docs.microsoft.com/en-us/dax/rankx-function-dax.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.