Creating an Average Measure for Multiple Columns

[dhlavek]

Hi,

I'm trying to to create a row in a matrix that would calculate the average for each column.  Each column is a different measure.  So I have 5 columns of measures, and want 1 row at the bottom that is the Average.

Any ideas?

Thanks.

[tex628]

It's possible, which dimension are you going to use for your rows in the matrix?

[dhlavek]

I'm sorry, if this isn't what you mean, but The columns would basically be different types of revenue(each its own measure) and the different rows would be various properties:

[tex628]

Exactly, 

If you want an average row then you would need to add a row to your properties table:

Property	ID
Property 1	1
Property 2	2
Property 3	3
Property 4	4
Property 5	5
Property 6	6
Average

This should mean that you have one row in your matrix which displays "Average" instead of a property. 

Now you go into your measures and write something like this: 

IF( SELECTEDVALUE(Property[property]) = "Average" ; Calculate(AVERAGE([amount]) ; ALL(Properties)) ; [Amount])

It should return an average when it finds that post in the properties table and otherwise just return the normal amount on the other posts. 

Hope it works,

Johannes