Forum Discussion

Suhel_Ansari's avatar
Suhel_Ansari
Icon for Helper V rankHelper V
6 years ago
Solved

Rank Column by Sub Category as Measure

Hi ALL,   I need DAX to rank the Category  and Sub Category  as the measure, as seem in the below screen shot I have created the which is not giving me the correct result i need a measure to rank m...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Suhel_Ansari 

Create a measure

Measure = RANKX(ALLEXCEPT('Table','Table'[category]),CALCULATE(SUM('Table'[my value])),,DESC,Dense)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Suhel_Ansari's avatar
Suhel_Ansari
Icon for Helper V rankHelper V
6 years ago

v-juanli-msft 

 

Thanks working as needed. :)