Conditional formatting based on multiple conditions in Pivoted Data

Hi Anonymous,  there are some corrections needed in the logic you provided:
It seems you missed a parenthesis in the CALCULATE function for both variable C and D

In the SWITCH function, DAX does not directly support using the && operator. Instead, you should use the AND function.

Here's the corrected DAX for your conditional formatting:

Color Format = 
VAR a = SELECTEDVALUE('Table'[Attribute])
VAR B = SELECTEDVALUE('Table'[Values])  -- Corrected the column name here from Value to Values
VAR C = CALCULATE(SUM('Table'[Values]), FILTER('Table', 'Table'[Attribute] = "Actual"))
VAR D = CALCULATE(SUM('Table'[Values]), FILTER('Table', 'Table'[Attribute] = "Target"))
RETURN 
    SWITCH(TRUE(),
        AND(a = "Profit%", C = 0), "Red",
        AND(a = "Profit%", D = 0), "Orange",
        BLANK()
    )

After creating the Color Format measure, go to your table visual where you wish to apply the conditional formatting.
Select the column you want to format (in this case, the "Values" column representing the Profit%).
Click on the drop-down arrow next to the column and choose "Conditional formatting" > "Font color" (or "Background color", depending on your need).
Choose "Format by field value", and in the dialog box, pick the "Color Format" measure you just created.
Apply the changes, and your table should now color the cells in the "Values" column for "Profit%" according to the conditions provided.
This will apply the conditional formatting to the Profit% based on the Actual and Target values.

 

If you find this helpful, please provide a kudo and mark it as an accepted solution.