Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Average Across rows with different measures

 

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? 

Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    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.

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    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.