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

     

     

Omega's avatar
Omega
Impactful Individual
8 years ago

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])