Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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 ...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

I had some success with the base table (uncombined) using this measure as a filter on a Table visual.

So if you set this to be a table flter and set to "is = 1", then if you have a multi-select slicer it will behave like an AND filter.

 

If you are happy with that I can combine the tables and show it working with the Value

 

AND_Filter = 
var CountOfFiltersSelected = COUNTROWS(FILTERS('Table2'[value]))
var DistinctCountOfValue = DISTINCTCOUNT('Table2'[value])
Return IF
		(
		CountOfFiltersSelected = DistinctCountOfValue,
		1,
		0
		)
adharia's avatar
adharia
Frequent Visitor
8 years ago

 Hi Phil_Seamark,  can you please show it " I can combine the tables and show it working with the Value.

I am also stucked with similar issue where I have column with multiple entries of skills. I want to filter out using multi select slicer with the AND logic.

For Example, I want to see the Employee with both SQL & PowerBI(skills) on selecting it from slicer.