Calculate Sum Filtering Out Measures

[JCBI1023]

Quick one for your masters. Thanks in advance. 

I am trying to calculate a sum which filters out some measures that I created. 

Customer Billed = CALCULATE(SUM(Sheet1[Total Hours]), FILTER(Sheet1 <> [ATO] || [Internal] || [Lost Time Hours] || [MC Labor Hours] || [Travel Hours]))

I need the "Total Hours" sans the measures that I created "ATO", "INTERNAL", etc.

I know my measure is close, but I can't get it to work. 

[Vvelarde · Accepted solution]

@JCBI1023

HI, i will try with:

CustomerBilled=

VAR NotBilleable=[ATO] + [Internal] + [Lost Time Hours] + [MC Labor Hours] + [Travel Hours]

RETURN
SUM(Sheet1[Total Hours]) - NotBilleable

Regards

Victor

Lima - Peru

[JCBI1023]

Perfect, sir. Thank you for your time. 

[Omega]

Can you try: 

Customer Billed = CALCULATE(SUM(Sheet1[Total Hours]), ALLEXCEPT (Sheet1, Sheet1[ATO], Sheet1[Internal], Sheet1[Lost Time Hours], Sheet1[MC Labor Hours], Sheet1 [Travel Hours])