It can be done -- one way or another.
The easiest one (imho) is by using a
Conditional Aggregate Filter.
Please find the attached as an example.
Please take a look at the [State] pill on Filters.
It is a Condition based on an Aggregated calc field.
Hope it could help understanding.