Forum Discussion
RANKX with groups
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
)Thank you Zubair. It worked however, i need to assign same rank when the average scores are same. For example; if there are two canidates with a score of 4.15, both of them should be assigned same rank instead of 2 consecutive ranks. Any suggestions on how to achieve that? Thanks
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!
I'm sorry for necroing this thread but when I try the proposed solution I get the error "EARLIER/EARLIEST refers to an earlier row contect which doesn't exist."
What creates the previous row context in your case but not mine? I have a plain table I try to rank by a grouping just the same way as in the example.
i am unable to select, getting red underline
= EARLIER ( Example_Rank[Group_Name] )
