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 ,
Here are the steps you can follow：
1. Create calculated table.
Letter_Slicer =
DISTINCT('Table'[Letter])Number_Slicer =
DISTINCT('Table'[Number])2. Create measure.
Flag =
var _select1=SELECTEDVALUE('Letter_Slicer'[Letter])
var _select2=SELECTEDVALUE('Number_Slicer'[Number])
return
IF(
MAX('Table'[Letter]) = _select1 || MAX('Table'[Number]) = _select2,1,0)3. Place [Flag]in Filters, set is=1, apply filter.
4. Result:
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
Thank you so much!
How should I go about it if multi-selection was needed for the [Letter] or [Number] column? Seems to not be able to work when trying multi-selection.