Forum Discussion
Wiene24
7 years agoHelper II
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...
v-lili6-msft
7 years agoCommunity Support
hi, Wiene24
If you want the rank to change if you change my slicers, please use ALLSELECTED instead of ALL.
don't use Omzetplaats = RANKX(ALL('dba Relatie');[Omzet];;DESC)
If you still have problem, please share a simple sample pbix file.
Best Regards,
Lin
Wiene24
7 years agoHelper II
v-lili6-msft Anonymous ALLSELECTED gave me the same result as ALL
All the debtornumbers are unique so that can't be the problem either.
How do I add a PBIX file? I don't see the paperclip sign to add it.