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 my Sub Category based of the Category, I need a measure not column, Any help would be appreciated. Thanks

 

I need is below but as a measure.

 

 

Thanks

 

 

Need Help

2 Replies

  • 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.