There are more than one way. The one that comes to mind is to use a dropdown that is to use multiple filter cards, each filtering for a different SKU. For example, you can add two separate filter cards to your dashboard, one for SKU A and one for SKU B. By selecting both SKU A and SKU B in their respective filter cards, you effectively create an AND operation between them.

You can use slicers (see filter chart types). Use a calculated field where you check for the existence of the SKUs within the column. Dropdown filters with multiselect.

There are limitations on what Dashboard filters can do for you. Each dimension you add to the filters will be an ADD condition (so criteria for ColumnA and ColumnB both need to evaluate to TRUE), but any additional options you add inside of each of these are used with an OR logic as you've described.

There could be alternatives, like creating flags for each SKU (not really scalable IMHO), that would allow you to say Contains SKU A needs to be TRUE and Contains SKU B needs to be TRUE. There might be other options by moving away from the Dashboard Filters and using Variables Instead and Beast Modes to create the filtering condition, but that would require some testing.