Subtotal Aggregations

[Anonymous]

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!

[d_gosbell · Accepted solution]

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') )

[Anonymous]

Yup, that's all it was, I just wasn't thinking about it clearly. Thanks for the help!