Forum Discussion

mikeoshields's avatar
mikeoshields
Icon for Helper I rankHelper I
5 years ago

Column Calculations in a Matrix

I have a PowerBI matrix of 6 columns of data...see below. The values are the sums of the last 6 months.    The example Excel worksheet below averages those 6 columns and does other calculatio...
  • mikeoshields's avatar
    mikeoshields
    Icon for Helper I rankHelper I
    5 years ago

    My apologies for not providing enough info.  The Excel data below is the result of a pivot.  After pivoting, I average the row for the 6 columns (Average Consumption) and do other math.  I need to do the same thing in PowerBI

     

     

     

    However, when I do a simple AVERAGE('Table'[Column]) in PowerBI in a Matrix, I do not get 23222.5.  I get 209.47 and I have no idea why.  Is there something extra that I need to in order to average values in a matrix?