Forum Discussion
Rank problem
Hello, everyone,
i need your help please
I want to sort by sales (Umsatz). Everything went great. However, when I add a column (Score), the Rank column is wrong. Why? lots of 1s appear. Is it my measure? I thank you for every answer.
Rank = CALCULATE(RANKX(ALL(Customers[POS-Partner]),[Umsatz]))
Initial situation:
How it should be:
3 Replies
Hi azaterol,
Just use RANKX(ALL(Customers[POS-Partner]),[Umsatz]) to create a DAX Column and then continue with the changes that you want to do in the visuals. Why use RANKX with CALCULATE!
Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BIHi azaterol ,
In order to better understanding your demands and give the right solution, could you please share with me some screenshots of your data after hiding sensitive information ?
Thanks for your efforts & time in advance.
Best regards,
Yadong Fang
