RANKX always returns 1

[Petan65]

Hello,

I went throught a lot of threads about this topic but any of the solutions hasn't work. I probably know why it's not working, but I don't know how to fix it. The reason is because all 3 customers have the same number on some line in database and power BI is not taking ranking it from the total.  

[Ritaf1983 · Accepted solution]

Hi @Petan65 
Try to do it with 2 measures : 

1. total sales = sum('Table'[Sales])

2. 

Customer ranked by Sales =

RANKX(

    ALL('Table'[Customer]),

    [total sales]

)

Unfortunately, I am out of the limit of images that I can attach to discussions.
So I prepared a sample PBIX, you can download it from This link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

Hi @Petan65 
Try to do it with 2 measures : 

1. total sales = sum('Table'[Sales])

2. 

Customer ranked by Sales =

RANKX(

    ALL('Table'[Customer]),

    [total sales]

)

Unfortunately, I am out of the limit of images that I can attach to discussions.
So I prepared a sample PBIX, you can download it from This link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Petan65]

Yes it works 🙂 thank you.

[Ritaf1983]

Happy to help 🙂

[Petan65]

Sorry to bother you again. I thought that it all works as it should and in final step it stopped :/. Do you know why card visual does not show filtered value? Istead it shows total. Thank you
This link

[Ritaf1983 · Accepted solution]

Hi @Petan65 
The card can't be filtered because it doesn't have a row context, unlike tables which are filtered by rows (categories), graphs which have this on axes, etc...
What do you want from card to show? There is no card on the linked file...

[Petan65]

Sorry in this file is the card. I need to show in card visual same result as have the table.

this link  

Edit: I've run into a second problem. When I would like to show the top 2 by month in the chart visual. It only works when I change X axis from date to "customer". Do you know how to make it work?
thank you