Forum Discussion
Redraidas1
Helper I
Helper IRANKX - Dense not working
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 ), [Tota...
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
Super User
Super UserRedraidas1 , 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