Slicer "AND' Operator

[Anonymous]

Lets say I have 2 tables A UNIT table and an OPTION table and the two tables are related by UnitID.

In my report I have an Option slicer and a visual displaying UnitId and Option.  Lets say in my slicer i have selected OPTION 35B.  In my visual I will see UnitID's, 123,456 and 987. But lets say I select in my slicer both 35B and 12A.  I only want to see 123 and 456.  I DO NOT want to see 987 because it does not have Option 12A.  Is this possible? If so how? 

UnitTable		OptionTable
UnitID		OptUnitID	Option
123		123	35B
456		123	12A
987		123	66F
		456	77X
		456	35B
		987	35B
		456	12A
		987	899K
		987	77X

[AlB · Accepted solution]

Hi @Anonymous

Have a look at this post.

I think they solved something very similar there 

[Anonymous]

Worked like a charm.  Thank You VERY VERY much.