How to get total as sum and average

[Anonymous]

Hi ,

In Power BI Matrix visual i want to get Col1 Total as SUM(Col1) and AVGCol2 as Avergae of the Column total meaning (AVG(Row1:Row3)). How can i achieve this?

	Col1	AVGCol2
Row1	10	19.72
Row2	9	10.18
Row3	6	31.69
TOTAL	25	20.53

[v-rzhou-msft · Accepted solution]

Hi @Anonymous 

Firstly you need to add a "Row Index" in your data model. We need to add it into Matrix Row Field.

Then add Col1 and Col2 into Matrix Value Field. We can use SUM and AVERAGE Function in Value Field.

My Sample:

SUM and AVERAGE Function in Value Field

Matrix:

Best Regards,

Rico Zhou

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