Average a Calculated Field

[eliwaite]

I have created a metric that measure how well an individual sales person is doing as a calculated field in a PowerPivot. I would now like to use this same metric to see how their team is doing on average (if Joe gets a 1 and Jim gets a 3, then the team would get a 2). I would like to be able to do this: =AVERAGE([Metric]) however PowerPivot only allows you to do an average on a column, not a calculated field. Any idea on how to do this, short of making a helper column?

 

[ImkeF]

You shouldn’t need a different measure for that. If you take your Team-field into the Pivot instead or on top of the person, your existing [Metric] should create average on that level as well.