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