Forum Discussion

snandy2011's avatar
snandy2011
Helper IV
7 years ago

Problem with rankx function for bottom

Hi, I just want to calculate bottom customer but having little problem with my DAX.   The scenario is that, I have a slicer with 3 values (Profit,Profit Margin,Sales).and on my another slicer wher...
Need Help
MFelix's avatar
MFelix
Super User
7 years ago

Hi snandy2011,

 

Do you have any repeat values when maing the rankx? meaning that instead of having 1, 2, 3, 4, 5,6 you have something like 1,2,3,4,6,6?

Seems to me like you have repeated ranking that causes to reduce number of values to present.

 

Search your data if any of the top/bottom 5 have more than 1 customer for the same ranking.

 

Regards,

MFelix

 

 

  • snandy2011's avatar
    snandy2011
    Helper IV
    7 years ago

    MFelix,

     

    Nope.. I don't think so.. 

     

    Check out the below screenshots,

     

     

    It Starts with rank 2..I dont understand why?

     

    But for profit or other measure, it shows correct rank.

     

    Can you please identify what is happening?

     

    Thanks for replying.

     

    snandy

    • MFelix's avatar
      MFelix
      Super User
      7 years ago

      Hi snandy2011,

       

      Starting the rank in 2 is the reason you have only 4 numbers, does for any chance for the 21.78 do you have two rows on your dataset that are exactly the same?

       

      Regards,

      MFelix

      • snandy2011's avatar
        snandy2011
        Helper IV
        7 years ago

        MFelix,

         

        Sorry for late reply. No, I dont think so, i have two rows which have excatly same value (21.78). 

         

        I did the same thing on excel also, But it shows me correct result.Please have a look of below excel result scrrenshots,

         

        Look, It shows me correct result. I miss this "Ken Heidel" Sales on Power Bi.

         

        Any clue to solve this ridiculous problem?

         

        Thanks,

        Snandy