How do I filter to IDs that have at least one Product that matches the slicer selection?

[ThePiecesFit]

I want to do the following: when a user selects a Product from the slicer, the visual should filter to the IDs that have that product and other products, not just to the rows that match that Product. The visual is supposed to show the popularity of products when the ID has a row that matches the slicer. 

I can't make a column that references the SELECTEDVALUE() and compares to the Product column because that's not allowed in a column. I've tried measures without success. 

Thanks for your time. 

PBIX: https://drive.google.com/file/d/1rcPWz8nWqBwqYAqAoFx5ma25tFDTLfy_/view?usp=sharing

Quick view without slicer selection:

Expected result when  "Table" is selected is.

ID	Product
1	Pen
1	Shoe
1	Table
4	Pen
4	Shoe
4	Table
5	Pen
5	Table

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

Hope this helps.

[ThePiecesFit]

Thanks! It works. Now I need to take the time to understand why 🙂 

[Ashish_Mathur]

You are welcome.

[MattAllington]

You can add a measure to a slicer as a filter. Write a measure 

has records = countrows(yourSlicerTableName)

and add it to the slicer as a filter so that the measure result is >0

[ThePiecesFit]

Maybe I'm confused, but it seems like your recommendation would filter the slicer options. But what I'm trying to do is reference the slicer value in another table such that it filters to the IDs that contain at least one matching value to the slicer. 

[MattAllington]

OK, sorry about that.  Slicers do not cross filter each other by default. Just go to "edit interaction" and turn on cross filtering between the slicers

[ThePiecesFit]

Maybe I'm not explaining myself correctly. When "Table" is selected in the slicer, I would like it to filter this table 

To look like this. That's because IDs 1, 4, and 5, all contain at least one instance of "Table." Then when I put this info in a visual it will tell the user that of the IDs that have at least one table, the most popular products are Table (3), Pen (3), and Shoe (2). Did I explain that clearly? 

ID	Product
1	Pen
1	Shoe
1	Table
4	Pen
4	Shoe
4	Table
5	Pen
5	Table