I have a table that has data for days of the week and a column for am and pm.

The drop down allows me to select two or more options ie Friday PM and Monday AM.

This return a row for all of the items that have a Friday PM and Monday AM.
What I want is only the items that meet both criteria ie both Friday PM AND Monday AM. I am also getting rows for items that only have one of the criteria. This seems to imply the filter uses OR logic where I want AND logic. Is there anyway of configuring this effect.
I cannot filter the table as I need to return all the items from the database as sometime I may need to have different criteria ie Thursday AM and Tuesday AM.

Is there anyway of achieving this outcome?

Thanks