Max and Min Price for Conditional Formating

Hi Elcin_7 ,

You can try formula like below and use it in conditional formatting:

MEASURE =
VAR max_ =
    MAXX (
        FILTER (
            ALL ( Raw_Data ),
            Raw_Data[Part_Number] = MAX ( Raw_Data[Part_Number] )
                && Raw_Data[Month Name Short] = MAX ( Raw_Data[Month Name Short] )
        ),
        [Price2]
    )
VAR min_ =
    MINX (
        FILTER (
            ALL ( Raw_Data ),
            Raw_Data[Part_Number] = MAX ( Raw_Data[Part_Number] )
                && Raw_Data[Month Name Short] = MAX ( Raw_Data[Month Name Short] )
        ),
        [Price2]
    )
RETURN
    IF (
        MAX ( Raw_Data[Price2] ) = max_,
        "red",
        IF ( MAX ( Raw_Data[Price2] ) = min_, "green" )
    )

Best Regards,
Adamk Kong

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