% averages not averaging out correctly

[wRw123]

I have a matrix table that's not averaging out correctly:

The percentages total is not averaging specifically. Correct total or average in this case should be (34.82 + 32.42)/2 = 33.62%. Why is that?

[amitchandak · Accepted solution]

@wRw123 , I think you need avg or Avg - Assume you already have measures like Divide(Sum(A), Sum(B)) . Means first Aggregate and then divide

Try a measure like

AverageX(Values(Date[Year]), [% Market Post Out])