Calculated column, distinct value based on filter

I'm not sure what the best method of solving my need here is, hence my question.

I have a table with events for cases, so each case can have multiple rows, depending on the events that happen.

I'm trying to find a way where I can catch the cases which don't have one or two specific event codes, and where the "case closed" date column is not blank (meaning case closed)

I've tried making a calculated column but I'm not getting the desired results.

The result I want is the column to tell me if the case meets the above requirements or not.

For example: a "true" if a specific case nr doesn't have one or the other of the event codes, and the date column not blank. Meaning all rows for the case nr should have this true or false