Forum Discussion
Solved
Pivot table summarization by Average calculates incorrect Total Averages.
This pivot is summarized by Average. The body of the pivot Averages correctly. The totals are whack. (Technical term).
Blanks are ignored in DAX. If 0 is represented in your data by a null / blank then that row will not be considered in the average in the numerator or denominator.
Blanks are ignored in DAX. If 0 is represented in your data by a null / blank then that row will not be considered in the average in the numerator or denominator.
All good points; thank you.
I need to check the zero value...
I imported the data from excel, and I am not an excel person; I am a SQL person.
I will try again, using SQL as the data source.
The zero needs to be included.
I belive Power BI is correct; I will double check.
Again, a huge thak you to all.
You rock!