IF logic between columns - filtering

[Outseid]

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.

Table 1	Table 2	Displayed
Open	Closed	TRUE
Open	Open	TRUE
Closed	Open	TRUE
Closed	Closed	FALSE

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

Kind regards,

Mario

[jthomson · Accepted solution]

Could try making a measure:

Display = if([tableoneopenfield]="Closed"&&[tabletwoopenfield]="Closed","Don't Display","Display")

which will then look at each combination and output Display except in the event where both of your columns say closed. You could then look to filter on that?