Selecting Multiple Conditions in a Filter with 'AND' condition

[Anonymous]

Hi! I'm working on a report that needs to incorporate a multi-selection that I'm doing through a filter. 

I'll describe the data and issue:
There are multiple 'facilities', and each facility can have multiple 'codes' associated with it.
Each facility will differ between the codes they have, and the goal of the report is to be able to filter by code and display the facilities that match the codes which are selected.

When the filter is used for a single code, the visual works fine and will display all the facilities which contain that code.
When multiple codes are selected, the goal is to display only the facilities that contain all of the codes selected. 

The current report will display every facility with any selected code, which is undesirable.

[Anonymous]

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

[Anonymous]

Thanks for reaching out, I went with an alternate approach to how I structured my report so I wouldn't have to search for multiple codes.