Forum Discussion

Wiene24's avatar
Wiene24
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...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

HI, Wiene24 

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's avatar
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's avatar
    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's avatar
      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.

      • v-lili6-msft's avatar
        v-lili6-msft
        Community Support
        7 years ago

        hi, Wiene24 

        You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

         

        Best Regards,

        Lin

         

  • Anonymous's avatar
    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