Conditional formatting by row issue

Hi Kerk ,

Please try:

Measure 2 = 
var _T= SUMMARIZE(ALLSELECTED('Bookings'),[Styles.Style],Bookings[Distance(Distance).Distance],[Swimmer], "Time",[PB_Formated])
VAR MinValue = MINX(FILTER(_T,[Styles.Style]=MAX(Bookings[Styles.Style]) && [Distance(Distance).Distance]=MAX('Bookings'[Distance(Distance).Distance])),[Time])
VAR MaxValue = MAXX(FILTER(_T,[Styles.Style]=MAX(Bookings[Styles.Style]) && [Distance(Distance).Distance]=MAX('Bookings'[Distance(Distance).Distance])),[Time])
VAR CurrentValue = [PB_Formated]
VAR Result = 
    SWITCH ( 
        TRUE,
        CurrentValue = MinValue, 1, -- 1 for MIN
        CurrentValue = MaxValue, 2  -- 2 for MAX
    )
RETURN
    Result

Output:

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