Forum Discussion

jeffreykeryk's avatar
jeffreykeryk
Icon for Helper I rankHelper I
10 years ago
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).  
Need Help
  • greggyb's avatar
    greggyb
    10 years ago

    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.

greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

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.

jeffreykeryk's avatar
jeffreykeryk
Icon for Helper I rankHelper I
10 years ago

I imported the data from a stored proc and bingo! Good numbers.

I hate excel...

But killing excel based processes has given me a wonderful career here in Silicon Valley.

I started with SQL Server v 6.21A, just to date myself.

 

Again, a huge tanks to all.

This thing rocks!