RANKX with RAND() to break ties does not work

[Anonymous]

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 ?

[amitchandak]

@Anonymous , refer

Rank Tie breaker
https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655
https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/