RANKX

[nuriac]

Hola, 

estoy haciendo un RANKX y me aparecen número repetidos. Esta es la fomula que estoy usando. He usado la misma para otro RANK pero con otra medida y me sale perfecto.

rank PED = if(HASONEVALUE('PEDIDOS DE VENTA'[Pedido]),RANKX(ALL('PEDIDOS DE VENTA'[Pedido]),[Fact Prev.Acum],,DESC),0)

[v-janeyg-msft]

Hi, @nuriac 

It’s my pleasure to answer for you.

According to your description,There is no problem with your current formula.How did you add column and modify the formula?Can you make it clear, or provide some sample data?So we can help you.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@nuriac , You have user rand() function to break ties

Refer
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

[nuriac]

the problem occurs when I add more columns to the table. how can I keep it in mind?