topic Re: Summing expenses for only 2 items in a column in DAX Commands and Tips

Summing expenses for only 2 items in a column

Anonymous — Fri, 23 Jul 2021 05:17:08 GMT

I am only new to Power BI and I need the sum of only 2 items in my table. E.g., I have a list of the following items with the expense next to them. All items are in the table for each month.

Cost of Sales Cost of Sales expense

Training hire 80000

Resources 20000

Wages 90000

venue hire 10000

I only want to calculate the sum of all Training hire and resources. I need to do a filter on my cost of sales column and the expenses together. I know it is easy but I am having difficulties getting in correct.

I have used:

Cost of 2 items = CALCULATE(sum('Cost of Sales'[Cost of Sales Expense]),('Cost of Sales'[Cost of Sales]="Training - Resources & Printing"),('Cost of Sales'[Cost of Sales]="Training - Venue Hire"))

but it isn't bringing anything up. It works when I just use the one filter so I am guessing I am adding the second filter incorrectly but I am not sure how to add it this dax.

Any assistance would be appreciated.

Thank you.

Re: Summing expenses for only 2 items in a column

amitchandak — Fri, 23 Jul 2021 05:46:59 GMT

Anonymous , Try like

Cost of 2 items = CALCULATE(sum('Cost of Sales'[Cost of Sales Expense]), filter('Cost of Sales', 'Cost of Sales'[Cost of Sales] in {"Training - Resources & Printing","Training - Venue Hire"}))

Re: Summing expenses for only 2 items in a column

Tanushree_Kapse — Fri, 23 Jul 2021 05:48:43 GMT

Hi Anonymous ,

Use the below DAX:

Cost of 2 items = CALCULATE(SUM('Cost of Sales'[Cost of Sales Expense]), FILTER('Cost of Sales','Cost of Sales'[Cost of Sales]="Training - Resources & Printing" || 'Cost of Sales'[Cost of Sales]="Training - Venue Hire"))

I hope this helps!
Mark it as a solution if it answers your question. Kudos are always appreciated!

Thanks.

Re: Summing expenses for only 2 items in a column

Anonymous — Fri, 23 Jul 2021 05:54:21 GMT

Thank you Tanushree_Kapse. Fantastic. Thank you again for your prompt response. It is appreciated.

Re: Summing expenses for only 2 items in a column

Anonymous — Fri, 23 Jul 2021 05:55:35 GMT

Thanks amitchandak . Appreciate your prompt reply. Thank you.