Hi!
I am trying to mark all regions except one (Southwest) as inactive (value = 3) automatically using a measure. This measure should look at the Sales region and if it is not "Southwest" it should mark it as 3.I did it manually and it worked but now I need it make it automated. I tried this formula : if(" Sales Region" <> 'Southwest', '3', null). The system tells me that the expression is correct but when I try to open a table with this measure it shows me an error.
I would appreciate any advice on this issue!