Hi @adsa,
Q: In your sample you are bringing in monthly data, is that also the case in your production model?
If so, please be aware of the fact that you can’t shift over a lower granularity without an additional allocation measure.
This affects your Avg calc so I removed that from FC Calc v2, below. Because it’s quite an extensive formula already I created a separate display measure where I correct the total by iterating over the Full FY and Month Name, when the Month Name isn’t INSCOPE.
Here’s your sample file.
Forecast.pbix (1.8 MB)
You can find more information and links to relevant content on fixing totals here:
I hope this is helpful.