Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Ranking a measure

I know this question has been aasked before, I've tried to follow some of the answers but failed...   I have a table called Results. This has ...   - a column called Player - a column called Poi...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    Based your sample, you could have a try with the measure below.

     

    SumPointsRank = 
Var summry=SUMMARIZE(ALLSELECTED(Results),[Player],"Sum",SUM(Results[Points]))
var tmp=ADDCOLUMNS(summry,"RNK",RANKX(summry,[Sum],,DESC,Dense))
return
MAXX(FILTER(tmp,[Player]=SELECTEDVALUE(Results[Player])),[RNK])

    If you don't want to create a temp table, you also could use the measure2.

     

    Measure2=
    RANKX(ALLSELECTED(Results),CALCULATE(SUM(Results[Points]),ALLEXCEPT(Results,Results[Player])),,DESC,Dense)

    Here is the output result.

     

     

     

    More details, you could refer to the attachment.

     

    Best  Regards,

    Cherry

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

I believe you are looking for something along the lines of:

 

Rank Measure = 
VAR __player = MAX([Player])
VAR __table = SUMMARIZE(ALLSELECTED('Table1'),[Player],"__Points",[SumPoints])
VAR __table1 = ADDCOLUMNS(__table,"__Rank",RANKX(__table,[SumPoints]))
RETURN
MAXX(FILTER(__table1,[Player]=__player),[__Rank])

There are other ways to do it.