CALCULATE based on evaluating OR condition between two dimension tables

[Fuzbe]

Hello,

I have the need to compute "Custom Revenue" by evaluating an OR condition between two dimension tables.  The following DAX expression failes:

Custom Revenue:=
CALCULATE (
[Revenue]
,Table1[Column1] = "Hello" || Table2[Column1]= "World"
)

I understand why the above expression fails, but can't seem to figure out how to write a formula that works.  Any ideas welcome!

[Aron_Moore]

I had something similar. Had to figure out if an account was past due then either use an abritrary date or the date on the record.

What I did was put the OR logic in a column, then used that column as the filter in my Calculate.