Forum Discussion
Using average values, how to change 0 in grand total in a pivot table into real numbers.
I have a lot of data using AVERAGE values in the column of the Pivot Table. But, there are some of my data that contains 0 and it makes the grand total is 0. All I want to do is changing the way that...
Creating PivotTable table you may add data to data model and add DAX measure for such average like
ASverage Without Zero:=CALCULATE(AVERAGEA(Table1[V]), Table1[V] <> 0)
- Thank you! It worked for me.
Glad it helped
