Ranking (Breaking Ties) for a Category based on a Measure with duplicate values for categories

[AntrikshSharma]

@Hemantsingh Try this:

Alphabetical Rank = 
IF (
    ISINSCOPE ( 'Sheet 1'[Step] ),
    VAR CurrentStep =
        SELECTEDVALUE ( 'Sheet 1'[Step] )
    VAR Result =
        COUNTROWS (
            FILTER (
                ALL ( 'Sheet 1'[Step] ),
                'Sheet 1'[Step] >= CurrentStep
            )
        )
    RETURN
        Result
)

.

Ranking = 
IF (
    ISINSCOPE ( 'Sheet 1'[Step] ),
    RANKX (
        ALL ( 'Sheet 1'[Step] ),
        [Total Reject] + DIVIDE ( [Alphabetical Rank], 100 ),
        ,
        DESC,
        SKIP
    )
)