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 a...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper 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
    Icon for Community Support rankCommunity Support
    7 years ago

    Anonymous ,

     

    You may try the measure below.

    Measure =
AVERAGEX (
    UNION ( ROW ( "Value", [Measure 1] ), ROW ( "Value", [Measure 2] ) ),
    [Value]
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hello

      Thanks for the help

      Does the "Union" work with only two measures? I m trying to include more than 2 and it is now working

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello v-chuncz-msft 

        I was able to replicate your measure in my matrix. Thanks for that.

        Now, would it be possible to create a overall avg based on the column? to display on bottom of the matrix?