Forum Discussion
Subtotal Aggregations
Hi,
I have a dataset with the following tables, among others: Month, Business Unit, Product Line, and Pounds Sold. I'm trying to create at table where the pounds are aggregated across a product line, but ignoring the Business Unit context, and keeping the Month context. A sample table would like like the following:
Business Unit A Business Unit B Business Unit C Total
Product Line 1 54,000 54,000 54,000 54,000
Product Line 2 120,000 120,000 120,000 120,000
Product Line 3 78,000 78,000 78,000 78,000
I would have a month slicer off to the side that would change the values in this table accordingly. I've tried several combinations of CALCULATE, FILTER, ALL, and ALLSELECTED to get a table like this, but no luck. Any help would be greatly appreciated!
If Business Unit is in it's own table that has a 1-to-many relationship to Pounds Sold, this should be as simple as the following:
CALCULATE( SUM( 'Pounds Sold'[Pounds Sold] ), ALL('Business Unit') )
2 Replies
If Business Unit is in it's own table that has a 1-to-many relationship to Pounds Sold, this should be as simple as the following:
CALCULATE( SUM( 'Pounds Sold'[Pounds Sold] ), ALL('Business Unit') )