locked
How do I create AVG measure in my cube? RRS feed

  • General discussion

  • [This is just for sharing information for those common asked questions collected from forums. If you have any better way or feedback, please directly reply in this thread so that community users can benefit from your answers.]

    Answer:

    The build-in aggregation AverageOfChildren is a semi-additive aggregation. It behaves the same as measures with aggregation type Sum on all dimensions except Time dimensions. If you want to create a measure to calculate the average sales amount of customers for all dimensions, then you can try this:

     

    1.      Create a measure [Customer Count] with aggregation DistinctCount for the customers.

    2.      Create a measure [Sales Amount] with aggregation Sum for the sales amount.

    3.      Create a calculated measure with expression: [Sales Amount]/ [Customer Count], and then set the additional properties.

     


    Please remember to mark the replies as answers if they help and unmark them if they provide no help
    Monday, June 21, 2010 1:32 PM