Forum Discussion

Spencer's avatar
Spencer
Icon for Helper II rankHelper II
10 years ago
Solved

Simple Sum Filter

Hi   If I have a dataset like the following: Status         Qty P                   10 P                   20 M                  50 M                  30 C                   25 C            ...
Need Help
  • SanderBeukers's avatar
    SanderBeukers
    10 years ago

    Assuming your table is called "Table":

     

    Measure = CALCULATE(SUM('Table'[QTY]);'Table'[Status]<>"C";'Table'[Status]<>"D")

     

    CALCULATE() allows multiple filters

Douwe's avatar
Douwe
Icon for Helper I rankHelper I
10 years ago

Something like this should work:

 

Sum = CALCULATE(SUM(Qty);FILTER(Status=C))

Spencer's avatar
Spencer
Icon for Helper II rankHelper II
10 years ago

Thanks for the reply Douwe but I don't think that will filter out the D's as well.

  • SanderBeukers's avatar
    SanderBeukers
    Icon for Advocate I rankAdvocate I
    10 years ago

    Assuming your table is called "Table":

     

    Measure = CALCULATE(SUM('Table'[QTY]);'Table'[Status]<>"C";'Table'[Status]<>"D")

     

    CALCULATE() allows multiple filters

  • Douwe's avatar
    Douwe
    Icon for Helper I rankHelper I
    10 years ago

    Extend it like this: Sum = CALCULATE(SUM(Qty);FILTER(Status<>"C" || Status<>"D"))