Filter Selection for Visuals Excluded on another Table

[dwelsh]

I am making an item sale Power BI with many different visuals.   For most of the visuals, I want to see sales on an item selected in my Item filter.  For example, if Apples is selected in the Item filter, one of my tables would show something like this:

Product	Qty Sold	Amount Sold	Margin	AvgSpent
Apples	20	$40	25%	$15

I also want to have a table showing items and qauntities sold with Apples.   My issue is, I don't know how to keep Apples from appearing like the below on my Sold With table: 

Sold With	Qty Sold
Apples	20
Bananas	17
Oranges	17
Grapes	15
Avacodos	14
Strawberries	13

Is there a way to automatically exlude whatever is choosen in the Item Filter from a table? 

[v-xuding-msft]

Hi @dwelsh ，

You could try editing interactions. For more details, please reference the document: Change how visuals interact in a Power BI report .

SampleSample

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

[dwelsh · Accepted solution]

Thanks @v-xuding-msft for the reply.  This doesn't quite do what I want it to as I need it to interact.   The table needs to show everything that sold in the same transaction as Apples.   I just need Apples to be excluded from the table.   

I found a way to get this to work by using a measure with the SELECTEDVALUE function.

ItemExclude = IF(MAX('Items2'[ItemName]) = SELECTEDVALUE('Items'[ItemName]), "TRUE", "FALSE")

Then I added the ItemExclude measure as a filter set to False on the Table.   The Item then is excluded from the 'Sold With' table.