Distinct Rank for each criteria

[Boja]

Hello,

Could you please help me make a rank col for the following dataset? Namely, the rank 1 should be assigned to the newest app version on each platform no matter the problem field. The rank column should be updated with every new release, so the newest version is always ranked first. Do you have any idea?

thanks

Platform	Version	Problem	Rank
Android	8.18	Message	1
Android	8.18	Call	1
Android	8.18	Network	1
Android	8.18	Video	1
Android	8.16	Call	2
Android	8.16	Network	2
Android	8.16	Video	2
Android	8.15	Message	3
Android	8.15	Call	3
Android	8.15	Network	3
Android	8.14	Call	4
iOS	8.1	Video	1
iOS	8.1	Call	1
iOS	8.1	Network	1
iOS	8.09	Network	2
iOS	8.08	Call	3
iOS	8.08	Video	3
iOS	8.08	Video	3
iOS	8.07	Call	4
Win	12	Network	1
Win	12	Call	1
Win	11	Network	2
Win	11	Video	2
Win	11	Message	2
Win	10	Call	3
Win	9	Video	4

[Zubair_Muhammad · Accepted solution]

HI @Boja

Try this calculated column

RANK_ =
RANKX (
    FILTER ( Table1, Table1[Platform] = EARLIER ( Table1[Platform] ) ),
    Table1[Version],
    ,
    DESC,
    DENSE
)

[Zubair_Muhammad · Accepted solution]

HI @Boja

Try this calculated column

RANK_ =
RANKX (
    FILTER ( Table1, Table1[Platform] = EARLIER ( Table1[Platform] ) ),
    Table1[Version],
    ,
    DESC,
    DENSE
)

[Zubair_Muhammad · Accepted solution]

@Boja

[Boja]

It works perfectly. Thanks Zubair!