Forum Discussion

nuriac's avatar
nuriac
Helper III
5 years ago

RANKX

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)
Need Help

3 Replies

  • nuriac's avatar
    nuriac
    Helper III
    5 years ago

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

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    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.