Forum Discussion

dw700d's avatar
dw700d
Post Patron
5 years ago
Solved

Excluding items while Summing

I am trying to create a measure that calculates the Sum of all spend for Type A while excluding Accounts 9,10,11. Can anyone help me with this?   Type   Spend Account A 20,000,000      1 ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can use a measure expression like this

     

    NewMeasure = CALCULATE(SUM(Table[Spend]), NOT(Table[Account] IN {9,10,11}))

     

    If Account is a text column, put each value in double quotes.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You can use a measure expression like this

 

NewMeasure = CALCULATE(SUM(Table[Spend]), NOT(Table[Account] IN {9,10,11}))

 

If Account is a text column, put each value in double quotes.

Regards,

Pat