Average Across rows with different measures

[Anonymous]

So I have a matrix with the rows beign made of calculated measures and the columns are fiscal week. 

what I need to add is an average column that takes into account a parameter.  The parameter is a fiscal week (eg. 16) and I need to average across the row upto and including that parameter week.  

My problem is that all theaverage calcs average within a column or a specific measure. is there a way to just add a column that will average across the row? 

[v-yingjl · Accepted solution]

Hi @Anonymous ,

You can create a measure like this to calculate the row average in matrix:

Average = 
CALCULATE(
    AVERAGE('Table'[Value]),
    ALLEXCEPT('Table','Table'[Category])
)

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.