Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Overall - Average - Multiple Measures

Hello

 

I created manually one new column per each "MonthYear" such as "Dec2017", "Jan2018", "Feb2018 for my matrix visual. Is there way to calculate a overall Average ?

I have a matrix as below and each month is a individual measure. I would like to have a column at the end with a overall average per row

 

Thanks

Need Help
Show and Tell

6 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    There should not be a need to write one measure per month.  If you can share the data (such that can be pasted in an Excel file) and describe the question, i can help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello Ashish

      I only found this wasy i can not unpivot my table, otherwise it will break my other relationships

      I already the put my need  in my previous comment.

      I would like to do an overall average measure based on the measure per month

       

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support
        7 years ago

        Anonymous ,

         

        You may try the measure below.

        Measure =
AVERAGEX (
    UNION ( ROW ( "Value", [Measure 1] ), ROW ( "Value", [Measure 2] ) ),
    [Value]
)