Average Column not calculating correctly in Matrix Row Totals

[jamiecc]

I have a matrix that needs to calculate an Average Premium. Basically $x / y = $avg x.

In my report I have:

I'm expecting to see Avg of 

1531.24

700.19

1505.89

The dataset does have some NULLs when it's expanded for some rows so I am thnking this might be messing it up? Basically my avg calc looks like this:

AvgPremiumAct = (Query1[PremiumAct])/(Query1[CountAct]) and I have the summarization set to Average.

How do I get this to show correctly?

Thanks for all suggestions.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...