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,

 

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

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi snandy2011,

     

    I wasn't abble to make a complete test since I don't have your data model and there are some parts of your measure that are not clear to me.

     

    On the  measure below, can you change the MAXX by MINXX and check if the Joni Sunderseam gets rank number 1 or 2?

     

    Rank Selection for Bottom =
IF (
    HASONEVALUE ( 'Ranking For Bottom'[Rank] ),
    VALUES ( 'Ranking For Bottom'[Rank Number] ),
    MAXX ( VALUES ( 'Top Analysis Unpivot'[Value] ), [Rank from bottom] )
)

    Since you have two values as 21.78 you are getting the higher value.

     

    Can you share some sample data by private message so I can make some addtional tests?

     

    Regards,

    MFelix