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 l...
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') )
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') )
Yup, that's all it was, I just wasn't thinking about it clearly. Thanks for the help!