Help with Rank

[San_eve]

I have data simillar to below table. 

Category	pair	Value
A	B	10
A	C	15
B	D	20
B	A	25

I need a rank column simillar ranking  as per category and value. Below O/p.

Category	pair	Value	Rank
A	B	10	1
A	C	15	2
B	D	25	2
B	A	20	1

I have tried Rankx but I am not getting the expected o/p. Any help is appreciated. Thanks.

[San_eve]

Works!!! Thanks a lot.

[DOLEARY85 · Accepted solution]

Hi,

try this in a calculated column:

Column = RANKX(

    FILTER('Table','Table'[Category] = EARLIER('Table'[Category])),

    'Table'[Value],,ASC

)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍