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
When checking the filter I find this
And regarding Colour Coding
Would somebody be able to see where is the error?
Thank you very much!
Jorge
Hi, Jorge
Can you provide a sample workbook?
ZZ