Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

dax formule for ranking

hello i need some help to get a ranking based on colum  of points 

i have a colum of points where i use the sum function on so i get a total of points per person now i want a ranking on that slike this

 

1. person 1  50

2. person 3  40

3. person 2  38

 

i also placed a screenshot of the data i the colum punten are the points that i use and i the colum name are the names of the person that need the ranking based on the columm punten

 

 

 

i hope someone can help 

dax need help

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    You would use the standard RANKX function with a filter as appropriate (for each etappe for example).  What have you tried and where are you stuck?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      i use this dax measure at the moment 

      klassering medewerkers = RANKX(ALL(Tour_De_France_Poule[Naam]),CALCULATE(SUM(Tour_De_France_Poule[Punten] )))
       
      i want the same as now but if people has the same points i want to get the rank by name so if person a has 75 points and person B i want person a on place 1 and person B on place 2
      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        so the outcome is like this 

        1.  person A    18 points

        2. person B      18 points

        3. person C      16 points

        4. Person D      16 points 

         

        so if the points are the same its on alfabet otherwise on highest points with the measure i now use it gives people the same rank if they have the same points this is the measure i use now what gives me the outcome with the same rank 

        RANKX(ALL(Tour_De_France_Poule[Naam]),CALCULATE(SUM(Tour_De_France_Poule[Punten] )))