Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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') )
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |