Hi, I am an existing Powerpivot user trying to get familiar with Power BI and am trying to convert my Powerpivot models over to BI. I have encountered an issue with a formula though - it is designed to give me forecast bias for sales. The first part works correctly:
Bias Calculation = divide('Key Measures'[Total Sales Quantity],('Key Measures'[Historical Forecast Units]))
This gives me in a table for each forecast month my sales bias. However, I have in my pivot model a formula that gives me a grand average at the bottom of my table and this does not seem to work in BI - I need the average of the bias calculation iterated over the months. My formula in powerpivot was:
Bias Measure = AVERAGEX(DISTINCT('S&OP_History'[Month]),'Key Measures'[Bias Calculation])
Can anyone advise how I can get the table to give me an average of the measure as the grand total?