Advanced filter

[gianmarco]

Dear All,

I can slice a table for the following row values:

0

1

2

3

What I want to achieve is a slicer where I can filter for the following options:

0 & 1,

0 & 2,

0 & 3.

In other words, you can slice for 1, 2 & 3 only but when you do you always slice for 0 as well.

Thank you very much

gianmarco

[lbendlin]

0 & 1

That's not what you mean, you need 0 || 1  (or, not and).

Usually this is achieved by UNIONing two tables, one static (with the 0) and one to feed the slicer (1,2,3).  The UNION needs to be done inside a measure and that measure needs to produce a 1/0 value that can be used as a visual filter.