topic Re: dax formule for ranking in DAX Commands and Tips

dax formule for ranking

Anonymous — Thu, 15 Jun 2023 11:08:29 GMT

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

Re: dax formule for ranking

lbendlin — Sat, 17 Jun 2023 01:50:13 GMT

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?

Re: dax formule for ranking

Anonymous — Mon, 19 Jun 2023 07:27:30 GMT

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

Re: dax formule for ranking

Anonymous — Mon, 19 Jun 2023 07:39:27 GMT

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

Re: dax formule for ranking

lbendlin — Mon, 19 Jun 2023 13:48:51 GMT

RANKX on multiple columns with DAX and Power BI - SQLBI

"Dynamic ranking on Rounded Sales and customer name"