You are trying to put OR condition with string values. Let say your first IF gets 'show' and 2nd IF gets hide then you conditions becomes:
this does not make sense.
You can put logical operators around OR like
Hope it clears the doubt.
I have a further problem now however. I am trying to do a variance of this year against last year. I have created a "Current Year" measure with the following formula:
and a "Last Year" measure with the following formula:
the 2 measures show 0
However if I put the year into the columns the correct figures display in the relevant year column. Why is this?