Forum Discussion
How to get total as sum and average
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 |
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.
1 Reply
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.