Forum Discussion
Solved
Issue Color in Dax
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.
cristianml , A color measure like
IF(not(isblank([_Actual Rev])) ,"Blue","Red")
and use in conditional formatting using field value option
1 Reply
cristianml , A color measure like
IF(not(isblank([_Actual Rev])) ,"Blue","Red")
and use in conditional formatting using field value option