Hi @Jango ,
Not sure if what you need is to have the total in rows or in columns has averages but you should do something similar to:
Matrix Values =
ISINSCOPE ( Table[ColumnHeaders] ),
SUM ( Table[Values] ),
DISTINCT ( Table[ColumnHeader] ),
CALCULATE ( SUM ( Table[Values] ) )
This will give for each column the sum of the values for the total column it will give you the average of the sums.
This needs to be adjusted to your model but here is an example:
Miguel Félix Did I answer your question? Mark my post as a solution!
Proud to be a Super User!Check out my blog: Power BI em Português