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?

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

    Lets assume the table has more columns such as "Type" where values are High , Critical , Low...And i want to select only High values while calculating the rank.

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

    I add a slicer to filter the "Type", the measure still works when the columns in the table visual are not changed. See the attached sample file below.