RANKX - Dense not working

[Redraidas1]

I have the below measure, however, as you can see in the screenshot, Dense is not working for some reason. Any ideas why?

Rank Measure (TOP10) = RANKX ( ALLSELECTED ( MainMarketQuality ), [Total Score],, ASC, Dense )

[V-lianl-msft · Accepted solution]

The reason is that the ranking options have duplicate values, so you need to rank multiple columns.

Please refer to this blog:

https://www.sqlbi.com/articles/rankx-on-multiple-columns-with-dax-and-power-bi/ 

[amitchandak]

@Redraidas1 , Measure rank is context sensitive , if you are any column outside MainMarketQuality table, then rank will inside that column

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale