Using RANKX with multiple columns to evaluate

[wayersGM]

Hello Community, 

I am trying to create a calculated column to deliver a rank. I have a table of data the looks something like this...

Test ID	Run ID
1	5
1	8
1	3
2	6
2	3
2	1
3	1
3	5
3	9

And Im looking to rank the Run ID from highest value to lowest for each Test ID, the expected table would show...

Test ID	Run ID	Rank
1	5	2
1	8	3
1	3	1
2	6	3
2	3	2
2	1	1
3	1	1
3	5	2
3	9	3

Any help from the community is much apperciated!!

[amitchandak · Accepted solution]

@wayersGM , Try new Rank

Rank = rankx(filter(Table, [Test ID] = earlier([Test ID]) ), [Run ID] )

[wayersGM]

@Jihwan_Kim , @amitchandak ,

Thanks for the help! Both solutions work as expected.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Rank CC =
VAR currentTestID = Data[Test ID]
VAR withinTestID_Table =
    FILTER ( Data, Data[Test ID] = currentTestID )
RETURN
    RANKX ( withinTestID_Table, Data[Run ID],, ASC )

[amitchandak · Accepted solution]

@wayersGM , Try new Rank

Rank = rankx(filter(Table, [Test ID] = earlier([Test ID]) ), [Run ID] )