Rank problem

[azaterol]

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:

[v-yadongf-msft]

Hi @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

[Shaurya]

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 BI

[azaterol]

@Shaurya unfortunately it didn't solve the problem. do you have another idea?