DAX 'If' statement with 'or' conditions

What if you have a multiples tables that need produce a Sum only if they have a value above 0 for example and I know this code isnt correct but im trying to explain   Calculate( Sum( if Column 1 >...