Forum Discussion
Rankx
Hi, I have a little problem with my RANKX. Two tables are involved: Costumor and Order I have a measure to calculate the total amount of the orders for each costumor: Omzet = SUM('dba D...
It's getting closer, but not working completely yet!
I'm using this formula now:
Omzetplaats = RANKX(ALL('dba Relatie');[Omzet];;DESC)
I want the rank to change if I change my slicers, that's why I didn't use ALLSELECTED.
But no idea why it leaves gaps now and why some are ranked as equals.
Kind regards,
Tim Wijnen
Hi Wiene24 ,
I am curious to know if the Ranks which shows equals have the same Debit number. this could be the reason it is causing you the equal ranks.
Also try the solution provided by Lin v-lili6-msft , looking at her results , looks like thats what you may be looking for.
Thanks,
Tejaswi