Average of Columns

[Anonymous]

Is there a way in a Power BI table to have a row at the bottom of the table that instead of showing the total of that column, shows the average of that column as shown below?

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may use AVERAGEX to add a measure and take a look at Table & matrix total label customization.

Measure =
AVERAGEX ( VALUES ( 'Table'[Project] ), CALCULATE ( SUM ( 'Table'[Value] ) ) )

[amitchandak]

Try if this can work

Do Avg of sum at project level. Reverse of example give below. Sum till project level and then avg. It should change GT to Avg.

refer this - https://community.powerbi.com/t5/Desktop/SUM-of-AVERAGE/td-p/197013

Hold result in summarize till required level and the take avg of the measure post that.

Or using isfiltered change the calc. GT should change

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[jbocachica]

Hi, do you want to add a row instead of using the total row?, if your measure is an average, then the total row will be an average.

[Anonymous]

The measure is not average and it is not even a measure.  It is the actual total for each day for each product.  There is no need to sum because there is only one result per day...but now that I think about it an average would give me the proper result for both since there is only one entry per day per project.

[jbocachica]

You just have to change the aggregation to average.

Regards