Forum Discussion
Solved
RANKX always returns 1
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 cu...
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 linkIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Ritaf1983
Super User
Super UserHi 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
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.
Yes it works 🙂 thank you.