Forum Discussion
Help - Calculated Column - % of Fcst by Row for Total Column
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?
1 Reply
- Greg_Deckler
Community Champion
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
