Forum Discussion

Paula's avatar
Paula
Icon for Helper I rankHelper I
8 years ago

Rank with the same numbers

Hello! i'm having some problems whit the function RANKX.   What can i do if i have the same amount in different categories and i want to do a rank? i want to see only the top 5, but the rank 5 is 1...
Need Help
Paula's avatar
Paula
Icon for Helper I rankHelper I
8 years ago

Hi Greg_Deckler

 

i'm using Dense, but the rank is the same when i have the same amount for different categories.

 

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

OK, so my understanding is that you want the top 5 categories. But, some of the categories have the same amount that you are ranking on. I guess my question is, how do you want it to work? In your scenario where you have a bunch of ranking "5", do you want it to randomly pick one? What is your expectation?

  • Paula's avatar
    Paula
    Icon for Helper I rankHelper I
    8 years ago

    Hi Greg_Deckler

     

    Yes!, i want to choose one at random. Is that possible?

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      8 years ago

      Possibly, you would want to use the RAND function to generate a random number. Alternatively, you could just use MAX or MIN on the category to grab the first or last one.

      • Paula's avatar
        Paula
        Icon for Helper I rankHelper I
        8 years ago

        Greg_Deckler

         

        In which part of the function should i use RAND?

         

        The function that i'm using is this:

         

        Rank = (RANKX(FILTER('Tabla1'; 'Tabla1'[Id Periodo] = EARLIER('Tabla1'[Id Periodo]))); RANKX(ALL('Tabla1'); 'Tabla1'[Monto]; ;DESC;Dense)))