Dax for Conditional Formatting KPI not Working

[Anonymous]

So I have a table of KPI values, all values shown in the matrix are the average of the result. For my target calculation I have a switch case as such: 

Targets = 
SWITCH(
    TRUE(),
    'Table'[MetricName] = "Days to Containment" && AVERAGE('Table'[Result]) > 10, "Red",
    'Table'[MetricName] = "Days to Containment" && AVERAGE('Table'[Result]) > 10, "Red",
    "Green"
)

Targets is a calculated column. In this program I am saying if the average result of a specific column name is greater than 10 then it is red if not it is green. Why does it show green for all values? I have tried it with and without the average of result.

[v-chenwuz-msft]

Hi @Anonymous ,

Please try this 

Targets = 
SWITCH(
    TRUE(),
    SELETEDVALUE('Table'[MetricName]) = "Days to Containment" && AVERAGE('Table'[Result]) > 10, "Red",
    SELETEDVALUE('Table'[MetricName]) = "Days to Containment" && AVERAGE('Table'[Result]) > 10, "Red",
    "Green"
)

Best Regards

Community Support Team _ chenwu zhu

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

[tamerj1]

Hi @Anonymous 

there is no row context in the marix visual. You need to add the column as a measure perhaps using SELECTEDVALUE and provide the same aggregation in the formatting measure