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.
@acohen-ih-corp read this post to get your answer quickly
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?