IN vs Not IN two different cards

Is there a way to create a filter in a dashboard includes only the selected value in a card and includes everything else but this filtered value in another card? for example, if I have 10 ids, one card should have the sales amount for the specific ID I'm filtering on and another card should have average sales of the 9 other IDs that I haven't selected. I want both of these in the same dashboard using a single filter

Best Answer