To display Average after Grand Totals in Matrix Visual

[techg]

Hi everyone,

I have a matrix visual with months displayed in columns (from January to December), categories in rows, and the sum of values in the value column. My requirement is to display the average value only after the grand total. Currently, it displays both the sum and the average for each month. Is there a way to display the average value only after the grand total?

Thanks

[Uzi2019 · Accepted solution]

Hi @techg 
Refer below blogs for better understanding

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Add-Total-Average-Column-within-Matr...

https://community.fabric.microsoft.com/t5/Desktop/Add-Measure-at-end-of-matrix-not-after-each-column...

https://community.fabric.microsoft.com/t5/Desktop/Add-YTD-amp-other-columns-to-the-end-of-a-matrix/m...

https://community.fabric.microsoft.com/t5/Desktop/Need-to-add-extra-column-in-existing-Power-BI-matr...

https://community.fabric.microsoft.com/t5/Desktop/Add-value-to-specific-column-in-matrix/m-p/2916408...

I hope the above post will help yu to solve your issue.

[fahadqadir3]

Share a sample dataset or an image/screenshot, what you're trying to achieve. you can present avg instead of total in a matrix visual.