Matrix - Conditional formatting based on the result of a DAX function

[rsramos78]

Hi, 

I have the below Matrix and want to change the background color of the line "+/- Var" only where the values are negative (<0). (If negative = red, if positive = green)

However the line is a calculation created by the DAX function below:

Values =

VAR result =

CALCULATE (

SUM ( 'BDR Combined'[Value] ),

VALUES ( 'BDR Type'[Type]),

VALUES ( 'BDR Months'[Month] )

)

VAR list =

SUMMARIZE ( ALLSELECTED ( 'BDR Combined'), [Year], [Type], "Result", result )

RETURN

IFERROR (IF(

result <> BLANK (),

result,

VAR Pipe =

CALCULATE ( SUM ( 'BDR Combined'[Value] ), 'BDR Type'[Type] = "Pipeline" )

VAR Tgt =

CALCULATE ( SUM ( 'BDR Combined'[Value] ), 'BDR Type'[Type] = "Target" )

RETURN

SWITCH (

SELECTEDVALUE ( 'BDR Type'[Type] ),

"+/- Var", Pipe - Tgt,

"% Var",( Pipe / Tgt ) * 100,

BLANK ()

)

),bLANK())

How could I achieve it?

Thanks in advance!

[rsramos78]

Hi @lbendlin , I've followed this path and was able to make it to work.

Thanks,

[lbendlin · Accepted solution]

create a "sister" measure that outputs the desired color names, and then use that as the basis for the conditional formatting of the main measure value in the matrix.