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

[Anonymous]

create a calculated column

Ranking = RANKX(FILTER(Test,Test[Transaction]=EARLIER(Test[Transaction])),Test[Value])