Format based on column values

Hi notintoexcel11 ,
Thanks for Ashish_Mathur  and VahidDM  reply.
The following additions were made:
Sample data:

Create a measure

Measure = 
VAR a = 
CALCULATE(
    MAX('Table'[Column2]),
    FILTER(
        'Table',
        'Table'[Column1] = "P2"
    )
)
RETURN
IF(
    a <> BLANK(),
    IF(
        a < 0.5,
        "Red",
        "Green"
    ),
    "Black"
)

Apply the measure to the font color

Final output

Best regards,
Albert He

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