Forum Discussion

Spencer's avatar
Spencer
Helper II
9 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
    9 years ago

    Assuming your table is called "Table":

     

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

     

    CALCULATE() allows multiple filters

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Spencer,

 

SanderBeukers’s reply seems well, you could also use below measures:

 

Total Qty without CD = SUMX(FILTER(ALL(Test),AND([Status]<>"C",[Status]<>"D")),[Qty])

 

Sum Except CD = CALCULATE(SUM([Qty]),FILTER(ALL(Test),AND([Status]<>"C",[Status]<>"D")) )

 

Result: (It have added two columns to display the measures)

 

Notice: my test table is ‘test’, you can modify it to your table name.

 

Regards,

Xiaoxin Sheng

Spencer's avatar
Spencer
Helper II
9 years ago

I might try that method in the future Anonymous. Thankyou very much for the reply.