Max in measure

Hi

Try using the dax below to get the maximum value for each row

MaxValue11 = 
MAXX(
    UNION(
        SUMMARIZE('Table', "Value", 'Table'[Green]),
        SUMMARIZE('Table', "Value", 'Table'[Grey]),
        SUMMARIZE('Table', "Value", 'Table'[Orange])
    ),
    [Value]
)

This is the result you want

Since there is no function in DAX that can be used to get the column names in a table, it is not possible to use DAX to change the color of a value based on the column where the maximum value is located.

Best Regards,

Jayleny

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