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
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , are you viewing it for Cancellation reason?

 

Then try like

Custom Col Cancellation Ranks =
Var RankByCancellation=
RANKX(
All(MyPT_Cancellations[Cancellation reason]), // or use allselected in place of all
CALCULATE(
COUNT(MyPT_Cancellations[No. of Clients]),
ALLEXCEPT(MyPT_Cancellations,MyPT_Cancellations[Cancellation reason])
),
,
DESC,
Dense
)
Return
IF(RankByCancellation<=9,RankByCancellation,10)

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • 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 

         

         

         

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.