Conditional formatting based on multiple conditions in Pivoted Data

Hi Anonymous 

I changed to your measure to the following, then it can work, you can refer it.

Measure =
VAR a =
    SELECTEDVALUE ( 'Table'[Attribute] )
VAR B =
    SELECTEDVALUE ( 'Table'[Value] )
VAR C =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Attribute] = "Actual"
                && [Area] IN VALUES ( 'Table'[Area] )
        )
    )
VAR D =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Attribute] = "Target"
                && [Area] IN VALUES ( 'Table'[Area] )
        )
    )
RETURN
    SWITCH (
        TRUE (),
        a = "Profit%"
            && C = 0, "Red",
        a = "Profit%"
            && D = 0, "Orange"
    )

Best Regards!

Yolo Zhu

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