Conditional Formatting - matrix row

Hello jcastr02,

Can you provide sample data or sample power bi file? Because I am able to achieve it in my file.

Hi jcastr02 ,

Create a measure like this:

Max_grey = 
VAR x = 
CALCULATE(
    MAX(Sales[Sale 2013]),
    ALLEXCEPT(
        Sales,
        Sales[Brand]
    )
)
RETURN
IF(
    MAX(Sales[Sale 2013]) = x,
    "grey",
    "white"
)

Then, do like this:

(The matrix in the picture is the effect I have achieved, I just repeat the operation again.)

Best regards,
Lionel Chen

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