IF logic between columns - filtering

Hi,

I will do my best to describe the issue I've encountered during my current project.

There are two tables - Table 1 and Table 2. Both contain various columns and are linked through a reference table with unique values. They are based on cases - both tables reference one case, just two different statuses from separate systems.

The requirement I was given is to display data where at least one of the case statuses is "open", as you can see below.

The dashboard filter will only let me display one of the two options from tables or both combined, but still won't get the result as below. 

I believe the table below will help.

Basically, it's:

1+0 = 1

1+1 = 1

0+1 = 1

0+0 = 0

So all records with '1' as a result should be displayed and the last one, with both statuses 'closed' should not be displayed.

Is there actually a solution to this available, or am I doomed to stick to Excel for this comparison?

Kind regards,

Mario