Forum Discussion

kirbynguyen's avatar
kirbynguyen
Helper II
5 years ago
Solved

Ranking Per Row in a Matrix

Hello,   I have data that when put in a Matrix looks like this (keep in mind the data isn't just one row per value, there are multiple rows per combination, so each value in each cell is an aggrega...
Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    5 years ago

    kirbynguyen 

    You can use the following measure to get the desired ranking.

    Ranking = 
IF( 
    HASONEVALUE(Table2[Category]) && HASONEVALUE(Table2[Name]),
    RANKX(
        ALLSELECTED(Table2[Category]),
        CALCULATE(SUM(Table2[Value]))
    )
)

     

     

Fowmy's avatar
Fowmy
Super User
5 years ago

kirbynguyen 

You can use the following measure to get the desired ranking.

Ranking = 
IF( 
    HASONEVALUE(Table2[Category]) && HASONEVALUE(Table2[Name]),
    RANKX(
        ALLSELECTED(Table2[Category]),
        CALCULATE(SUM(Table2[Value]))
    )
)