Forum Discussion
slicer logic (OR | AND)
Hi! when i select 2 items in slicer i want to see records that have both selected items. table A: id value 1 q 2 w 3 e table B: id table_A_id value 1 ...
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 e
now i'm trying to slice table with field value:
in slicer i select q1 & q2 not q3:
- q1
- q2
q3
so 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
but i need so (wilter work as logically AND):
id table_A_id value TableA_Value 1 1 q1 q 2 1 q2 q
Oh I get it. Sorry.
I still think the combined table is the way to go but add a column that carries the value of 1.
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).
I have to head out soon, so can give you a working example in a few hours.