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.
Hi Vvelarde,
Thank you.
In the formula for the measure, I did not understand this part:
Sum('Table'[A])/Sum('Table'[B]))
What is 'Table'[A]and 'Table'[B] representing here with respect to the table I have used as an example.
'AB' is the name of one column, there is no column named A or B.
Thanks.
Change to this:
AverageAB = AVERAGEX(SUMMARIZE('Table';'Table'[week];"TheAverageAB";Average('Table'[AB]));[TheAverageAB])