Ranking within a matrix

[Anonymous]

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
A	00P	1000	4
A	00I	500	5
A	00L	3000	3
A	00R	4000	2
A	00E	5000	1
B	00Q	8000	1
B	00W	6000	2
B	00Z	4000	3
C	00X	10	3
C	00C	20	2
C	00V	30	1
C	00B	5	4

I want my values ranked in order of highest to lowest but only for the corresponding Transaction and Code rows.

How can I achieve this?

Thank you

W

[v-joesh-msft · Accepted solution]

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.