Selecting Multiple Conditions in a Filter with 'AND' condition

HI Anonymous,

So you mean you want the custom the filter effect to achieve 'all match item' filter effects on your visuals, right? If that is the case, the default filter effect should not be suitable for your requirement.

You may need to create a disconnected table as source of slicer and write a measure formula to compare table records and selections to return flag. Ater these steps, you can use this formula on visual level filter to filter records.

If you are confused about coding formula, can you please share some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng