Help with measure - IF Condition in between does not work

[annlois]

Hi!

So I am creating somehow a 'traffic light' indicator for a chart. It's basically a pie chart that turns to green OR red when the value is true from a measure 

Column1Green = IF(SUM(Column1[count])<=8681,1,0)

Column1Red = IF(SUM(Column1[count])>9838.466666666667,1,0)

This is working. Now i am trying to put yellow as an indicator when its between 8681 and 9838.

But it's not working. Any leads on how I can make this work?

Here's the measure I created for when it needs to turn to yellow:

Column1Yellow = IF(and(SUM(Column1[count])>8681,SUM(Column1[count]))<9838.466666666667,1,0)

[amitchandak · Accepted solution]

@annlois , Create a measure like this and use in conditional formatting using field value option

measure =
var _1 = SUM(Column1[count])
return
Switch(True(),
_1 <=8681 , "Green" ,
_1 >9838.466666666667, "Red" ,
"Yellow"
)

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4