Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Rankx producing incorrect order

Hello,   I am trying below calculated column in my dataset to return a rank to limit my bar chart    Custom Col Cancellation Ranks = Var RankByCancellation= RANKX( All(MyPT_Cancellations), ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak 

Sorry, i tried Allselected but doesnt changed anything. Let me share table format and output 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , have tried with

All(MyPT_Cancellations[Cancellation reason])

 

Allselected(MyPT_Cancellations[Cancellation reason])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    amitchandak 

    Tried both format but still doesnt worked 

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak 

      Please guide how can remove dense rank and give separate rank if the value is same for the cancellation reason, I am doing top 19 + 20 (Other)

       

       

      So, in this case rather than having 12 rank for more than 1 record I want serial rank no matter if the values are same.

       

      I tried removing dense but the result show 1 and then 20 for all