Forum Discussion
Ranking For few columns
Hi I have a sample below table, which i hav the data this way. Productname Subcategory revenue Coolers homecooler 345 Refregirator Mini refregiration 543 Fulltotal Total 456 ...
amitchandak
Super User
Super UserAnonymous , Try measures like, assume revenue is a measure
Product Rank =
rankx(allselected(Table[product name]), [revenue])
Sub category Rank=
rankx(allselected(Table[subCategory name]), [revenue])
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-3-of-3-the-finale