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.
- v-lili6-msft7 years agoCommunity Support
hi, Wiene24
You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
- Wiene247 years agoHelper II