dax formule for ranking

[Anonymous]

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 

[lbendlin]

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]

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]

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

[lbendlin]

RANKX on multiple columns with DAX and Power BI - SQLBI

"Dynamic ranking on Rounded Sales and customer name"