Forum Discussion

darshaningale's avatar
darshaningale
Resolver 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.

v-jingzhang's avatar
v-jingzhang
Community Support
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
Resolver 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
    Community Support
    3 years ago

    Which kind of filters? Can you provide some examples?

    • darshaningale's avatar
      darshaningale
      Resolver 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
        Community 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.