Rankx producing incorrect order

Anonymous 

For the first question, replace the allexcept to following:

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]),
Filter(Allselected(MyPT_Cancellations), MyPT_Cancellations[Cancellation reason]=MAX( MyPT_Cancellations[Cancellation reason])
),
,
DESC,
Dense
)
Return
IF(RankByCancellation<=9,RankByCancellation,10)

For more, please share a sample table or pbix(Not image),  that would make your current situation clear for us.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.