Forum Discussion
Filtering a Table based on two non-interacting slicers
Hello, Is it possible to perform the following? Dataset sample: Name Letter Number Test1 A 1 Test2 A 1 Test3 B 3 Test4 C 2 Test5 C 4 Test6 D 5 Test7 E ...
Hi Rondel ,
If you want to consider using multiple selection, you can use the SELECTCOLUMNS() function:
SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn
Flag =
var _select1=SELECTCOLUMNS('Letter_Slicer',"letter",'Letter_Slicer'[Letter])
var _select2=SELECTCOLUMNS('Number_Slicer',"number",'Number_Slicer'[Number])
return
IF(
MAX('Table'[Letter]) IN _select1 || MAX('Table'[Number]) in _select2,1,0)
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Seems that the filter doesn't work when doing multiple selection on just one of the columns: