Highlight rows in a matrix table with a maximum value

Hi, subhendude ;

You could create measures as follow:

firstlocation = 
IF(ISINSCOPE('Location'[Location]),
   MAX('Data'[Location]),
   CALCULATE(MAX('Data'[Location]),FILTER('Data', 
     [Latency]=CALCULATE(MAX('Data'[Latency]),ALLEXCEPT('Data','Data'[Component])))))

value = 
IF(ISINSCOPE('Location'[Location]),
    MAX('Data'[Latency]),
    CALCULATE(MAX('Data'[Latency]),FILTER(ALL('Data'),[Component]=MAX('Component'[Component]))))

condition = 
VAR _max =
    CALCULATE ( MAX ( Data[Latency] ), FILTER(ALL('Data'),[Component]=MAX('Component'[Component])))
    return IF([value]=_max,1)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.