Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

RANKX with RAND() to break ties does not work

Hello,

I have a problem trying to break ties in a RANKX function using RAND().

Here is my measure without RAND :

TOP_5_Profession_M_norand = RANKX(ALL(Infos_Devis_AFN[Profession]),[NB_AFN_M])

Works fine : but I need to break ties so i'm adding +RAND() to [NB_AFN_M] to get [NB_AFN_M_rand] and then:

TOP_5_Profession_M = RANKX(ALL(Infos_Devis_AFN[Profession]),[NB_AFN_M_rand])
 

But this is not working at all, every time I refresh the visual, i get different values and i do not understand why...

 

Could someone helps me to understand why ?