Find common values based on selected category

[fz1]

I am very new to PowerBI and am trying to dynamically find the common values in one column based on selected category(ies) in another column. For example, I would like to know from the following table what are the common Items based on the Store column:

Such that, if I have a slicer with the Store names and select all stores, I'll get the following results:

Or if I select Stores A and B on the slicer, the table will update to this:

Thank you very much!

[parry2k]

@fz1 I see, I also have the video on exact question Suppliers Products Price Analysis - Compare Price of ONLY Common Products between Selected Suppliers...

[parry2k]

@fz1 I think this video on my YT channel will get you going How to override slicer selection to return all records | PeryTUS - Power BI How To - YouTube

[fz1]

thank you so much for the response, but I believe what I'm trying to do is a little different than what the video is showing as my data is structured differently. The video shows the first two records have the same combination of "Work Order" and "Responsible" (1234567 and Dan) - my dataset is different in that each combination of "Work Order" and "Responsible" is unique. So, to go back to my requirement: I am trying to find what Items are common in the Stores; to give another example, if I select stores B and C, it will show only the common items in both stores (=bread and cheese).

To give a little more context, all my data is currently in one table (so I wouldn't need to link any tables) and I am using one of the columns as a slicer (in the above example, it is the Store column). Also, the real dataset I am using has about 10k records.

In summary, I am trying to make multiple selections on the slicer and have it return the intersecting records on my table based on the slicer as opposed to returning all the records (which is what it is currently doing).