cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dw700d
Helper IV
Helper IV

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  SpendAccount
A20,000,000     1              
A20,000,0002
A20,000,0003
A20,000,0004
A20,000,0005
A50,000,0006
A10,000,0007
A10,000,0008
A50,000,0009
A50,000,00010
A50,000,00011
B10,000,0003
B10,000,0003
1 ACCEPTED SOLUTION
mahoneypat
Super User IV
Super User IV

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
Tahreem24
Super User II
Super User II

@dw700d , Please refer my below screen shot:

Capture.PNG

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, and Sales Analysis Report
mahoneypat
Super User IV
Super User IV

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors