Efficient and effective metrics

Hi ajdm2007 ,

I create a table as you mentioned.

Then I think you can create a measure like this template.

Measure1 =
VAR fastest_specialist =
    MAXX ( ALL ( 'Table' ), 'Table'[Max resolution time(Hrs.)] )
RETURN
    CALCULATE (
        FIRSTNONBLANK ( 'Table'[Specialist], 1 ),
        'Table'[Max resolution time(Hrs.)] = fastest_specialist
    )

So you can change the column as you want and it will give you what you want.

Measure = 
VAR _Measure2 =
    CALCULATE (
        FIRSTNONBLANK ( 'Table'[Specialist], 1 ),
        'Table'[Max resolution time(Hrs.)]
            = MAXX ( ALL ( 'Table' ), 'Table'[Max resolution time(Hrs.)] )
    )
VAR _Measure3 =
    CALCULATE (
        FIRSTNONBLANK ( 'Table'[Specialist], 1 ),
        'Table'[First reply] = MAXX ( ALL ( 'Table' ), 'Table'[First reply] )
    )
RETURN
    // _Measure2
    _Measure3

Best Regards

Yilong Zhou

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