Power BI Challenge 8 - Jira IT Service Desk Analysis

[AntrikshSharma]

@MudassirAli Does this help:

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

@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]…