Forum Discussion

Helper 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...

Community Support

7 years ago

Just try this formula:

Omzetplaats 2 = RANKX(ALL('dba Relatie'),[OMZET] )

or

Omzetplaats 3 = RANKX(ALLSELECTED('dba Relatie'),[OMZET] )

Result:

For your formula, if you just drag [DebiteurNummer] into visual, it will work too.

Best Regards,

Lin

Wiene24
Helper 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
  Community 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
  - Wiene24
    Helper II
    7 years ago
    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.
- Anonymous
  Not applicable
  7 years ago
  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

Related content