How do I create a Weighted Average in DAX

Greetings, and lets see if I can do this correctly with the graphics.


The DAX code which is a typical (as they say) weighted average template follows this text.

The table that contains the columns; [PRV] & [PRI QTY] to be multiplied and produce the product [Asset Value], follow the DAX code.

At each row, I want to divide the [Asset Value] by the Sum of the [PRI QTY], not the individual values at the roes themselves.

As you can see from the column [WAvg], I am getting the same result as [PRV]; why, because I am not retaining the "TotalGSF" from the VAR in the DAX code.

I thought by using the VAR, the "TotalGSF" would be retained as a constant for the DIVIDE function, but not true, its obvious the row value of [PRI QTY] is being used.

How do I retain the "TotalGSG" for use in the DIVIDE function?

Thank you.