In and not in slicers

[JoG]

Hello,

I need to filter a fact table with missions done and not done for a given date interval.

Here is the model :

D_MISSION : missions referential, contains the hierarchy of all missions

D_CALENDAR : calendar table

F_CA : fact table, contains missions done for contacts and the revenue

I have a date slicer to filter the date interval. I have another slicer with the mission hierarchy that filters the missions done.

How can I create a slicer with the missions not done for a contact ?

[lbendlin]

Create a measure that evaluates to 1 for not done and 0 for the other scenario.  Use that measure as a filter on your visual.