Forum Discussion

JCBI1023's avatar
JCBI1023
Helper III
8 years ago
Solved

Calculate Sum Filtering Out Measures

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(Sh...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    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

     

     

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

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's avatar
JCBI1023
Helper III
8 years ago

Perfect, sir. Thank you for your time.