Rankx + Rand() not working

[devesqdeves]

Hello , i am new  to the community and kinda new to power bi .

I am trying to rank a column(client) based on a measure that i created ( hc fac value) , and to that measure i added rand(hc fac value rand) , to not have any equal values, but the rank is showing as if it exists equal values , i am really struggling..

Can someone help me out please?

[amitchandak]

@devesqdeves , You have to add Rand() in Rank (Measure Rank)

Rank(Table,formula) +rank()/1000

[devesqdeves]

Thanks for the input ! But it is not working yet :c

@amitchandak 

@MFelix 

it shows like this

my rank measure =

IF (

HASONEVALUE ( Client[Cliente] ) && [HC FAC Value]>0,

RANKX(All(Client[Cliente]),[HC FAC Value],,DESC) + RAND()/1000)

already tried with dense and skip and still not working :s

it should be 1,2,3,4,5,6,7,8,9 etc , but its still repeating, i dont know what to do , need heelp plz

[MFelix · Accepted solution]

Hi @devesqdeves ,

I assume that you have an ID for each of your client if not please create one with the client number (must be unique values) then add the following measure:

Rank_Without_Duplicates =
IF (
    HASONEVALUE ( Client[Cliente] )
        && [HC FAC Value] > 0;
    RANKX (
        ALL ( Client[Cliente] );
         (
            CALCULATE ( [HC FAC Value] )
                + INT ( CALCULATE ( MIN ( Client[Client ID] ) ) ) / 100000
        )
    )
)

Check result attach.

[devesqdeves]

It worked !! Thanks !!

[MFelix]

Hi @devesqdeves ,

Don't forget to mark the correct answer to help others.