Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

need help with a rankx measure

hello i need some help with a rankx measure i currently use this measure:

klassering renners = RANKX(ALL(Wielrenners[Renner]),CALCULATE(SUM(Wielrenners[Points] )))

but the outcome is now like this
 
Krijgerss21_0-1687173368039.png

i want that it counts till 10 but if the points are equil like position 8 i want it on the alphabet so marco will be 8, mikel 9 and rui 10
can someone help me what i need to change at my measure ?

4 REPLIES 4
Mahesh0016
Super User
Super User

@Anonymous it's not possible because of Macro Frigo , Mikel Landa and Rui Costa three  are same [Punten] so it's give same rank.

Anonymous
Not applicable

is there not another way so that if the points are the same it looks at the names in a decending order 

@Anonymous can you have other value column in that table.

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.