Single Slicer Driving Filtered and Inverse Filtered Tables

[dreck]

I'm trying to have a slicer drive a filtered table and an inverse filtered table on the same page. I've attached screenshots of simplified data, relationships, and visual of "Inverse of Filtered" that I am trying to accomplish. Anyone have any ideas?

Data and RelationshipsInverse of Filtered visual that I'm having trouble creating

[dreck · Accepted solution]

I found the following by @Greg_Deckler that I was able to adapt to solve the problem:

https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290 

[vanessafvg]

please can you explain what you mean by the inverse, everything that isn't what you selected?  please provide some sample data in text format to create a solution. 

[dreck]

Correct, it would be everything that is not selected. Here are the simplified data tables:

LookupProduct:

Category	Product ID	Product Name
A	12	Blue
A	14	Red
B	72	Green
B	22	Purple

Sales:

Date	Product ID	Amount
4/1/2023	12	20
4/2/2023	12	30
4/3/2023	14	40
4/4/2023	22	50
4/5/2023	22	60
4/6/2023	72	70

Thanks for the help!