Conditional Formatting broken by Custom Sort

^{Hi CrystalC ,}

^{Please follow these steps:}

^{(1) My test data:}

^{(2) Add a new measure}

CF Rank =

VAR _max =

    CALCULATE (

        MAX ( 'Mockup'[Sched Dprts] ),

        ALLEXCEPT ( Mockup, 'Mockup'[Carrier] )

    )

VAR _nextmax =

    CALCULATE (

        MAX ( 'Mockup'[Sched Dprts] ),

        FILTER ( ALL ( Mockup ), [Sched Dprts] < _max )

    )

RETURN

    SWITCH ( SUM ( Mockup[Sched Dprts] ), _max, "Green", _nextmax, "Yellow" )

^{(3) The result is as follows :}

^{Best Regards,}

^{Gallen Luo}

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