Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all, hope you are doing good. I started using the RANKX function but I'm having a strange scenario that my limited knowledge of DAX cannot explain.
Here is the file in Google Drive (let me know if you can download it):
The problem is with the measure [Rank overall]. Is not showing the overall rank starting from 1. It is starting from another number. I need it to start from 1, then 2, 3, etc.. based on the measure [IPK] to rank.
The measure [Rank by subcategory] works perfectly.
[Rank overall] = Rank overall = RANKX( ALL(IPKR); CALCULATE([IPK]); ; DESC; Skip)
Any doubt please let me know. Thank you very much in advance!
Kind regards,
Andy
Solved! Go to Solution.
Modify the measure [IPK], [Rank overall]
IPK2 =
DIVIDE (
CALCULATE ( SUM ( IPKR[Pasajeros] ), ALLEXCEPT ( IPKR, IPKR[Ramal] ) ),
CALCULATE ( SUM ( IPKR[Kilómetros] ), ALLEXCEPT ( IPKR, IPKR[Ramal] ) ),
0
)
Rank overall = RANKX(
ALLSELECTED(IPKR),
IPKR[IPK2], , DESC, Dense
)
Best Regards
Maggie
Where is the measure [Rank overall]? From your pbix, I can't see it.
Does the "Ranking" refer to the measure [Rank overall], if so, what's the matter with the rank number, what is the correct rank, could you give an example?
Best Regards
Maggie
Hi Maggie, my bad, I uploaded the wrong file... I fixed the link. Please give it a new try!
Thanks for your help 🙂
Regards,
Andy
Modify the measure [IPK], [Rank overall]
IPK2 =
DIVIDE (
CALCULATE ( SUM ( IPKR[Pasajeros] ), ALLEXCEPT ( IPKR, IPKR[Ramal] ) ),
CALCULATE ( SUM ( IPKR[Kilómetros] ), ALLEXCEPT ( IPKR, IPKR[Ramal] ) ),
0
)
Rank overall = RANKX(
ALLSELECTED(IPKR),
IPKR[IPK2], , DESC, Dense
)
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |