Displaying Grand Total & AVG to a table in Power BI

[Gou303]

Hi community!

I'm working with a report in Power BI, and I'm looking to display the average & sum at the end of the table as new row.

Sum - Enabled " Total " 

AVG - ? 

Date	Sales	OrdersValue	Orders	Manual Orders
05/07/2021	100	91.141 €	37	45
08/07/2022	200	11.05 €	73	51
03/03/2023	202	11.171 €	81	49
03/09/2023	302	8.535 €	37	45
01/05/2023	400	9.709 €	40	55
Total	Sum	Sum	Sum	Sum
AVG	?	?	?	?

Info: values are coming from Calculated Measures other than the Date column ,

Is  there any solutions to display AVG with Total values Or just AVG row at the bottom of the table ? 

I've gone through some posts in the community, but I haven't come across a solution that fits my specific requirement.

[Anonymous · Accepted solution]

Hi  @Gou303，hello amitchandak, thank you for your prompt reply!

As far as I known, we can only choose one of these ways to aggregate data as shown below:

As a workaround, we recommend that you create another summary table that displays both the totals and the averages, and then place it below the first table visual to achieve a similar effect to displaying the averages at the bottom of the table:

SummaryTable =
UNION(
SUMMARIZE(
'Table',
"Category", "Total",
"Sales", SUM('Table'[Sales]),
"OrdersValue", SUM('Table'[OrdersValue]),
"Orders", SUM('Table'[Orders]),
"Manual Orders", SUM('Table'[ManualOrders])
),
SUMMARIZE(
'Table',
"Category", "AVG",
"Sales", AVERAGE('Table'[Sales]),
"OrdersValue", AVERAGE('Table'[OrdersValue]),
"Orders", AVERAGE('Table'[Orders]),
"Manual Orders", AVERAGE('Table'[ManualOrders])
)
)

We can also change the color of the column headings to the same color as the background color to hide the column headings:

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Gou303 , Check if this approach can help

https://medium.com/@amitchandak/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be