Ignoring Filters

[mpalha]

Hello,

I have a master dimension with the formula below:

If(Not Match(channel, 'Control'), vendor)

I'd like my measure below to ignore this dimension when a value is selected. How do I go about doing that?

Sum({<channel={'Control'}>}sales)

[Don_Stocks_ · Accepted solution]

To simplify your problem, I would suggest loading your vendor values that aren't 'Control' into a separate field.  Then you can very easily ignore the selection in your set analysis.

Load
...
If(Not Match(channel, 'Control'), vendor)      AS Non_Control_Vendor
...
From ...

Use that new field as your filter, and then your set analysis is simply:

Sum({<Non_Control_Vendor=, channel={'Control'}>}sales)