Skip to main content

Hello!

 

I am trying to colour a map based on 4 options

 

If Value1 >0 and Value2>0 Then Green

If Value1 >0 and Value2<0 Then Blue

If Value1 <0 and Value2>0 Then Yellow

If Value1 <0 and Value2<0 Then Red

 

I created a measure with the following formula, and the calculation is valid.

 

If{INCLUDE [Country], [Value1]: [Revenue Variance]} <0

and {INCLUDE [Country], [Value2]: [Revenue Variance]} <0

Then 1

ELSEIF {INCLUDE [Country], [Value1]: [Revenue Variance]} <0

and {INCLUDE [Country], [Value2]: [Revenue Variance]} >0

Then 2

ELSEIF {INCLUDE [Country], [Value1 ]: [Revenue Variance]} >0

and {INCLUDE [Country], [Value2]: [Revenue Variance]} <0

Then 3

ELSEIF {INCLUDE [Country], [Value1 ]: [Revenue Variance]} >0

and {INCLUDE [Country], [Value2]: [Revenue Variance]} >0

Then 4

eLSE 0

END

 

The problem is I can only see value with 1 and 4 on the filter

 

Filter IF Else IF

 

When checking the filter I find this

 

pastedImage_7.png

 

And regarding Colour Coding

 

pastedImage_8.png

 

Would somebody be able to see where is the error?

 

Thank you very much!

 

Jorge

4 answers
0/9000