Forum Discussion

darshaningale's avatar
darshaningale
Icon for Resolver II rankResolver II
3 years ago
Solved

Rank based on category column

I have three columns Category , subcategory and Amount column.  I am adding category , subcategory and sum of amount column in table. I want to calculate rank (sum of amount column) based on only Ca...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi darshaningale 

     

    Sorry I think this measure should be helpful.

    Rank = RANKX(ALLSELECTED('Table'[SubCat]),CALCULATE(SUM('Table'[Amount])))

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

darshaningale's avatar
darshaningale
Icon for Resolver II rankResolver II
3 years ago

You are a lifesaver. Thank you..What if I want to add some filters to this ??

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Which kind of filters? Can you provide some examples?