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'm working on creating some fcst accuracy metrics, currently in PowerPivot but will migrate to BI. I need to create a calculated column which works out the % share of the row forecast out of the overall forecasted value.
I've currently got to the below which seems correct however my Totals are not adding up to 100%. My data is stored at SKU level by date, when I go to Pivot the data, I need the forecast % total for that given month adding up to 100% and they need to be in a calculated column as the results are feeding into a different calculation. Any ideas on what I need to change?
This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149
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 |
---|---|
113 | |
103 | |
75 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |