remove all rows with same id when a condition applies.

You want to create a conditional column where your request type is Infrastructure then 1 else 0.

Afterwards, duplicate this whole table and then group by on Problem ID with a Max aggregation on your conditional column  to give a unique list of Problem IDs with 1 when they have infra and 0 if they never do.

You can then merge this back into the original table joining on Problem ID then filter out the 1's.