Create the filter as normal, select the condition tab, click by Formula and enter [Region]!="West"
Works great, thanks.
can you do this with Nulls?
Lets say you had a table with many dimensions and the only measure was row counts.
lets say you wanted to create a data healthcheck dashboard, which alerted you to data issues. One of those issues could be the appearance of nulls in any particular Dimension.
basically if a dimension does not yet have a null in its group, how could you filter the table so it showed nothing but still if a null appeared in an extract it would be displayed.