Getting the average an the total in a matrix in power bi

[Luzadriana255]

Hello,

I need to create a matrix with cost data against product data, normally you can only get the total sum of the costs, but I also need to get a column with the average. The problem is that if I use the average, it will give the average of the average of each month. and I need the average of the sum of every month plus the normal sum of every month.

Thank you for your help!

I should get something like in the following table:

Product	Jan	Feb	Mar	April	May	Jun	Jul	August	Sept	Oct	Nov	Dez	Durschnitt	Total
Boots	3400	0	1000	6000	5000	1500	700	3400	1700	4500	19000	22000	5683,33333	68200
Shirts	1700	1500	0	980	0	780	0	300	1000	6500	2400	5000	1680	20160
Socks	500	50	700	960	0	650	45	0	600	700	1200	1500	575,416667	6905