slicer logic (OR | AND)

Question

Hi!when i select 2 items in slicer i want to see records that have both selected items.table A:id &nbsp; &nbsp; &nbsp;value1 &nbsp; &nbsp; &nbsp; &nbsp; q2 &nbsp; &nbsp; &nbsp; &nbsp; w3 &nbsp; &nbsp; &nbsp; &nbsp; e&nbsp;table B:id &nbsp; &nbsp; table_A_id &nbsp; &nbsp; value1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q1 &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q23&nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q34&nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q45&nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q1&nbsp;i want to filte table A by values in table Bso if a select q1 AND q2 i should see only table A id = 1 value = q&nbsp;Any ideas if it is possible to make slicer work as logically AND?

phil_seamark · Answer

Hi&nbsp;Anonymous,&nbsp;You could combine the two tables into 1 table in the Query Editor or in DAX as one approach.

anonymous · Answer

what will it give to me? i need to filter them dynamically in the dashboard

phil_seamark · Answer

You will be able to filter the data dynamically. &nbsp;If you use your TableB[Value] field as a slicer, it will include any rows selected&nbsp;&nbsp;id	table_A_id	value	TableA_Value
1	1	        q1	q
2	1 	        q2	q
3	2	        q3	w
4	3	        q4	e
5	5	        q1

anonymous · Answer

&nbsp;It seems that I can't describe well what i want)))) i changed you table a bit to make it clear:id	table_A_id	value	TableA_Value
1	1	        q1	q
2	1 	        q2	q
3	2	        q3	w
4	3	        q1	enow i'm trying to&nbsp;slice table with field value:in slicer i select&nbsp;q1 &amp; q2 not q3:q1&nbsp;q2q3so the result in power bi will be (filter works as logically OR):id	table_A_id	value	TableA_Value
1	1	        q1	q
2	1 	        q2	q
4	3	        q1	e&nbsp;but i need so (wilter work as logically AND):id	table_A_id	value	TableA_Value
1	1	        q1	q
2	1 	        q2	q&nbsp;

phil_seamark · Answer

Oh I get it. &nbsp;Sorry.&nbsp;I still think the combined table is the way to go but add a column that carries the value of 1.&nbsp;Then a measure can be used to count the number of items selected by the slicer (in this case 2, and compare with the distinct number of values per ID).&nbsp;I have to head out soon, so can give you a working example in a few hours.

Forum Discussion

slicer logic (OR | AND)

7 Replies

Related content

Slicer by logic conditions

Logic problem?

Slicer AND logic

Slicer with AND Logic

Reusable slicer choices logic