I can not create a calculated AVG measure.
There is a table: year - value.
The year is the same.

I create dimension - year.
I create a measure - a value and make it sum.
I create a calculated member: AVG ([Measures] .val).
As a result, I always get the amount for the year that I would not do.
Watched links:
https://msdn.microsoft.com/en-us/library/ms146067.aspx
https://technet.microsoft.com/en-us/library/aa224826%28v=sql.80%29.aspx

I do everything as there, but it does not work.
I'm new to OLAP.

Thank you in advance!

    1 answer 1

    As it turned out, you need to create another measure with aggregation count on the required field and divide the sum of the field in the calculated member by the number of.

    And already calculated member used as the final value.