Rank Column by Sub Category as Measure

[Suhel_Ansari]

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

[v-juanli-msft]

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 · Accepted solution]

@v-juanli-msft 

Thanks working as needed. 🙂

---

---