issue with creating a measure s in DAX

[Anonymous]

i am trying to create a measure for background color but i am having issue.

BackgroundColor = IF(SELECTEDVALUE('5DaysSLA'[Working Days]) < 3,"#008000",IF(SELECTEDVALUE('5DaysSLA'[Working Days]) >3 && SELECTEDVALUE('5DaysSLA'[Working Days]) <5," #FFBF00","#FF0000")

Please help 

[Icey · Accepted solution]

Hi @Anonymous ,

")" is missing at the end of the expression.

BackgroundColor =
IF (
    SELECTEDVALUE ( '5DaysSLA'[Working Days] ) < 3,
    "#008000",
    IF (
        SELECTEDVALUE ( '5DaysSLA'[Working Days] ) > 3
            && SELECTEDVALUE ( '5DaysSLA'[Working Days] ) < 5,
        "#FFBF00",
        "#FF0000"
    )
)

In addition, you can also try this measure, which works the same as yours:

BackgroundColor =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( '5DaysSLA'[Working Days] ) < 3, "#008000",
    SELECTEDVALUE ( '5DaysSLA'[Working Days] ) > 3
        && SELECTEDVALUE ( '5DaysSLA'[Working Days] ) < 5, "#FFBF00",
    "#FF0000"
)

Best Regards,

Icey

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