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
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