DAX Weighted Average

[clarkpaul]

I'm having trouble finding the weighted average by month.  I have the following data:

The solution I'm trying to get to is the column Weighted Avg. 
Any help would be appreciated

[amitchandak]

@clarkpaul , Can you explain the formula?

[clarkpaul · Accepted solution]

So the solution was to build 2 measures:

% of Hist Total = sum('Table'[Hist Value])/sumx(all('Table'),'Table'[Hist Value])

Weighted Avg = sum('Table'[Hist AR Value])*'Table'[% of Hist Total]

[clarkpaul]

I take the percentage of the Machines Sold by month to the total machines sold and multiply that result by the Feature Attach Ratio.