Issue Color in Dax

[cristianml]

Hi,

I have an issue with the following measure trying to change the color depending of type of measure.  It show me the name of the color instead of changing the color.

_0 Color = 

VAR RESULT = SUMX(VALUES('Calendar'[Date]),IF(AND(0<>([_Actual Rev]),0<>Backlog[_Backlog Rev]),Actuals[_Actual Rev],Actuals[_Actual Rev]+Backlog[_Backlog Rev]))

RETURN

IF([_Actual Rev],"Blue","Red")

Each measure comes from different tables:

_Actual Rev = SUM(Actuals[Revenue])

_Backlog Rev = CALCULATE(SUM(Backlog[Value]),Backlog[Metric]="Backlog")

Hope you can help me.

[amitchandak · Accepted solution]

@cristianml , A color measure like

IF(not(isblank([_Actual Rev])) ,"Blue","Red")

and use in conditional formatting using field value option