How to create a "reverse" slicer filter? Select thing and shows the except

[gluizqueiroz]

I have a table with some sales, like the following:

Id_Product	Product	Group	Subgroup	Value_Sold	Date_Sold
1	Computer	Eletronics	IT	1000	2018-05-01
1	Computer	Eletronics	IT	1000	2017-06-01
1	Computer	Eletronics	IT	1000	2017-07-01
2	Mouse	Eletronics	Peripherals	25	2018-05-01
2	Mouse	Eletronics	Peripherals	25	2018-06-01
3	Headphone	Eletronics	Sound	35	2018-12-01

I need to make a entire page that suffer the inverse action of slicer.

On my table I have sales on May/June/July and December and on 2017 and 2018.
If the user selects DECEMBER/2018 for example, my entire page should show only sales that NOT HAPPENED on DECEMBER, something like the inverse filter. 

The user select a month and the page shows values different than selected value. 

By the way, my page has a table and I show wich product not sold on selected date, I cannot show only SUM of Value_Sold, I need show the products with their own group, subgroup and name.

Is it possible?

[Greg_Deckler]

OK, I was able to accomplish it. So, what you need is a Separate table for your dates like:

Table = DISTINCT('Table'[Date_Sold])

Relate that to your main table. Create a slicer based upon this new table but Edit Interactions such that it does not interact with your table. Now, create a Measure like:

Measure 2 = 
VAR __selected = MAX(Table8[Date_Sold])
VAR __current = MAX(Table7[Date_Sold])
VAR __yearSelected = YEAR(__selected)
VAR __monthSelected = MONTH(__selected)
VAR __yearCurrent = YEAR(__current)
VAR __monhtCurrent = MONTH(__current)
RETURN
IF(__yearCurrent = __yearSelected && __monhtCurrent = __monthSelected,0,1)

Now, filter on that for Greater than 0. 

See Page 4, Tables 7 and 8 of attached.

[Victormar]

Hello!

I know this topic is old, but I have a similar problem and this approach seems to be an option.

In my case I have 4 different states for a project (that would be a slicer) and then I have a table with many part numbers which have a state as well.

My goal is to revers filter based on these rules: 

- If I select P, I want to see A, B and C.

- If I select C, I want to see B and A.

- If I select B or A, I want to see A.

Does anybody has any idea on how to accomplish it?

Many thanks in advance!

[Greg_Deckler · Accepted solution]

I built one of those once:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266