Repeated rank = 1 using Rank function

[Marico]

Hello All,

I am creating the summarized table with the following measure:

Summarised students =

  CALCULATETABLE(

        SUMMARIZE(

            Students,

            Students[StudentName],

            "TotalScore",sum(Students[Score]))

      )

After creating this table, I am trying to Rank the students based on their scores in descending order through the following Column/ Measure:

StudentRank = RANKX(ALL(Students[StudentName]),CALCULATE(sum(Students[TotalScore])),,DESC,Dense)

StudentName	TotalScore	Rank
S1	90	1
S2	98	1
S3	96	1
S4	91	1
S5	99	1

I want to rank them correctly and then select Top 3 from the above list.

Thank you so much for your help!

[amitchandak · Accepted solution]

@Marico , You do not need summarize table for that , or create measure on that and use with columns of that table

StudentRank = RANKX(ALL('Summarised students'[StudentName]),CALCULATE(sum('Summarised students'[TotalScore])),,DESC,Dense)

For TOPN

AverageX(keepfilters(topn(3, all('Summarised students'[StudentName],CALCULATE(sum('Summarised students'[TotalScore])), desc)),CALCULATE(sum('Summarised students'[TotalScore])) )