Forum Discussion
Solved
RANKX with groups
Need some regarding the Rankx function. I need to assign ranks to the candidates on their average scores grouped by their group_Name. I tried the following and recieveing an error: Rank = rankx(a...
Sorry! My bad! Its working the way it should..the problem was fixed by fixing the decimal points of average grades to 2 digits..Thank you so much again!
Hi ontario234
Try this instead
RANK =
RANKX (
FILTER (
Example_Rank,
Example_Rank[Group_Name] = EARLIER ( Example_Rank[Group_Name] )
),
Example_Rank[Average_scores],
,
ASC,
DENSE
)
i am unable to select, getting red underline
= EARLIER ( Example_Rank[Group_Name] )