Forum Discussion

Marico's avatar
Marico
Helper IV
3 years ago
Solved

Repeated rank = 1 using Rank function

Hello All,   I am creating the summarized table with the following measure:   Summarised students =   CALCULATETABLE(         SUMMARIZE(             Students,             Students[StudentName...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    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])) )

     

amitchandak's avatar
amitchandak
Super User
3 years ago

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])) )