Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Ranking within a matrix

Hi,   I have a simple Matrix table.   The table has 2 rows (Transaction & Code) and 1 value.   My ideal ranking that I want is the column at the end.    Transaction Code Value Ranking ...
Need Help
Tips and Tricks
Tutorial Requests
  • v-joesh-msft's avatar
    v-joesh-msft
    6 years ago

    Hi Anonymous ,

    You can try the following measure:

    Ranking =
RANKX ( ALLSELECTED ( 'Table'[Code] ), CALCULATE ( SUM ( 'Table'[Value] ) ) )

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi Anonymous ,

You can try the following measure:

Ranking =
RANKX ( ALLSELECTED ( 'Table'[Code] ), CALCULATE ( SUM ( 'Table'[Value] ) ) )

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.