Forum Discussion
Solved
Average error in total
HI, Please see below the example. In a table/matrix the total of average value is different from the real average. This is what it look likes in power BI: And when we calc...
You need to do an Average of the averages because the total that you see is Allvalues/All Rows.
TO solve this use:
AverageAB = AVERAGEX(SUMMARIZE('Table';'Table'[week];"TheAverageAB";Sum('Table'[A])/Sum('Table'[B]));[TheAverageAB])
You can change with your columns name.
