Solved: RANKX of Value for category

Slaw · ‎12-27-2022

Hello all,

I tried to create RANKX based on the category to present the highest rank for specific Title. But the outcome for my rankx was 1 in each row.

rankCategory = RANKX(ALL(Table[Category]), Value)

Sample of the data used

Desired outcome

ouaelaam · ‎12-27-2022

Hi,
Try this formula :

Rank = RANKX(CALCULATETABLE(Table,ALLEXCEPT(Table,Table[Category])),Table[Value],,DESC)

ouaelaam · ‎12-27-2022

Hi,
Try this formula :

Rank = RANKX(CALCULATETABLE(Table,ALLEXCEPT(Table,Table[Category])),Table[Value],,DESC)

RANKX of Value for category