Filter Data across an id column using logic with multiple slicers

[crastello]

Hi All, 

I am wondering if this is possible.
I have some product data associated with Ids and the goal is to let users filter for ids where there is a corresponding product mix across those ids.

Sample Data

Id	Product
1	a
1	b
1	e
2	a
2	b
2	c
3	a
3	c
3	e
4	d
4	e
4	f
5	g
5	h
5	i

I would like to utilize two slicers the user can pick ids from to filter the data to return ids where any value from slicer 1 is found and any value from slicer 2 is found. Example here would be Id has any product from slicer 1 AND any product from slicer 2

has any of	and has any of
slicer1	slicer2
a	e
b
c
d

to return something like this

Id	Has Product Mix
1	yes
3	yes
4	yes

Any Help is appreciated and thank you for your time.

[v-cgao-msft · Accepted solution]

Hi @crastello ,

Please create 2 new tables:

Table 2 = DISTINCT('Table'[Product])

Table 3 = DISTINCT('Table'[Product])

Then use them to create two slicers.

Then create a new measure:

Measure = 
VAR _table1 = CALCULATETABLE(VALUES('Table'[Id]),'Table'[Product] IN ALLSELECTED('Table 2'[Product]))
VAR _table2 = CALCULATETABLE(VALUES('Table'[Id]),'Table'[Product] IN ALLSELECTED('Table 3'[Product]))
VAR _table3 = INTERSECT(_table1,_table2)
VAR _result = IF(MAX('Table'[Id]) IN _table3,"YES")
RETURN
_result

Result;

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data