Forum Discussion

k_sun's avatar
k_sun
Frequent Visitor
4 years ago
Solved

Measures to calculate Ranking

I've below data set and need to identify the ranking of "Player" based on their "Score" average.   PlayersMaster Player Team Type Player1 Team1 Local Player2 Team1 Overseas Playe...
Need Help
Show and Tell
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    RANK_Type = RANKX( ALLSELECTED( PlayersMaster[Player] ), [Total],,, DENSE )
    Rank_Overall = 
RANKX(
    ALL( PlayersMaster[Player] ),
    CALCULATE( [Total], ALLEXCEPT( PlayersMaster, PlayersMaster[Player] ) ),
    ,
    ,
    DENSE
)

CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago
RANK_Type = RANKX( ALLSELECTED( PlayersMaster[Player] ), [Total],,, DENSE )
Rank_Overall = 
RANKX(
    ALL( PlayersMaster[Player] ),
    CALCULATE( [Total], ALLEXCEPT( PlayersMaster, PlayersMaster[Player] ) ),
    ,
    ,
    DENSE
)

  • k_sun's avatar
    k_sun
    Frequent Visitor
    4 years ago

    Thanks a lot CNENFRNL for your reply. However, I'm not clear about the [Total] field that you've used for both measures.

    In my expected results I've considered the Average Score for each player as the Total.   

    Please explain. 

    Thanks

    • CNENFRNL's avatar
      CNENFRNL
      Community Champion
      4 years ago
      Total = AVERAGE('MatchScores'[Score])