Forum Discussion
Average of Columns
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?
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] ) ) )
5 Replies
- jbocachica
Resolver II
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.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
- amitchandak
Super User
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 
v-chuncz-msftCommunity Support
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] ) ) )
