SUM Where clause across different tables

[Anonymous]

Hi, 

I need to create a new measure withim my 'comp_spend' table whereby it sums the total value based on whether or not a flag = 'Y' across 3 different tables. 

Example logic that I am trying to achieve:

Total_value_removed = calculate(sum(comp_spend[comp_value]), 'app_new'[remove_flag]="Y" OR 'app_old'[remove_flag]="Y" OR 'app_changed'[remove_flag]="Y")))

The 3 tables app_new, app_old and app_changed have all been joined onto the comp_spend table. 

[johnt75 · Accepted solution]

You should just be able to change the OR to ||

Total_value_removed =
CALCULATE (
    SUM ( comp_spend[comp_value] ),
    'app_new'[remove_flag] = "Y"
        || 'app_old'[remove_flag] = "Y"
        || 'app_changed'[remove_flag] = "Y"
)