Forum Discussion
Sum a Measure at a Category level
I have the following measure of which I need to calculate at a particular category level before summing for these categories. The measure I need to calculate is [Savings per Item] * [Savings Volume...
Hi amitchandak thank you very much for taking the time to reply,
The ALLEXCEPT works to calculate my measure at the correct level. But then how do I SUM that measure for each of those results?
Savings by Subcategory = CALCULATE([Savings per Item] * [Savings Volume] * 'General Volume Switch'[General Volume Switch Value],ALLEXCEPT(ClientTable,ClientTable[Region],ClientTable[SubCategory]))
i.e. once I have this above I then need to sum these values for each Region and Subcategory to get a total value for all Regions and Subcategories for which the value above is greater than zero
Hey Anonymous I know this is from 3 years ago, but were able to solve this? I am trying to do the same exact thing you described here and haven´t found a solution yet.