I have a similar problem with my total column average. I was trying to insert a screenshot from Snipping tool, but it doesn't seem to be working...
I have the following values of Data Type: Decimal Number; Format: Percentage; Default Summarization: Average;
Count Value Week
1 43% 10/04/2015
1 43% 11/01/2015
1 43% 11/15/2015
1 43% 11/22/2015
1 43% 12/06/2015
2 40% 12/13/2015
I expect the total average for these weeks (i.e. 2015 Q4) to be 42.14%. However, my Power BI matrix table shows 40%.
How can I fix this? There are no 0 values in the datasource (seemed to be a problem for other people with similar problem). This is also not a result of incomplete data for Q4 because in that case the average shown by Power BI would be 19.62%. Can it be related to the fact that the Week is coming from a separate Date table I created myself rather than from the main datasource?
Your help and insigts are much appreciated!