Forum Discussion

Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
7 years ago

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...
Need Help
Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
7 years ago

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

 

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

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