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(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. 

 

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

     

     

3 Replies

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

  • 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