Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Subtotal and Grandtotal to Show the Averages of each Monthly Total

Hi Gurus,



I have this table below that needs to show the average of each month in the subtotal for each assignee and the grand total to show the average of each subtotal.  



Same goes if this table expands with multiple assignees, where it should calculate the average of each assignee subtotal.


Any help would surely be appreciated. 🙂



Hi @polaris3028,


Per my knowledge, it is not possible to show the average of detailed values in subtotal row and show average of each subtotal in grandtotal row. By default, both grandtotal and subtotal calculate results with SUM aggregation. Even if we generate a measure to get AVERAGE rather than SUM, the measure will calculate based on detailed rows. That is to say, it is not possible to calculate based on subtotal level.



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors