cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
acohen-ih-corp Regular Visitor
Regular Visitor

Calculate Sum of Costs of Food and Costs of Beverage

I need to create a new measure that calculates for the sum of the costs of food and the costs of beverage as presented in the image below at the bottom of the matrix shown under expenses. How would i do that with static numbers and filter them according to their current hierarchy? They are GL level 4 in this matrix, where level 1 is expenses.F&B Inquiry.PNG

2 REPLIES 2
Super User
Super User

Re: Calculate Sum of Costs of Food and Costs of Beverage

@acohen-ih-corp read this post to get your answer quickly

 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




acohen-ih-corp Regular Visitor
Regular Visitor

Re: Calculate Sum of Costs of Food and Costs of Beverage

Thank you, for the advice and link.

 

Any idea how i would sum the "cost of food" and "cost of beverage" in this Matrix visual?

I can't directly reference the two rows for the calculation in DAX. Any suggestions?

Cost of F&B.PNG