Is it possible to have an average measure summed in PowerPivot.
I am rolling up timesheet data and subtracting the actual from the estimate for each feature then rolling that up to the release level.
I am using PowerPivot measures to get the estimate and the actual.
The estimate is an average because it is stored in the task in the timesheet database.
The actual is a sum of all time booked to that task.
Estimate:=Average([ROMEstimate])
Actual:=Sum([Capital])
Variance:=[Actual]-[Estimate]
This works on the feature level but not the rolled-up release level. I do not want an average there but a sum of the averages below that.
<tbody>
</tbody>
To avoid the average I did try a separate table with the estimate for each task but could not get that measure to work.
Any ideas?
I am rolling up timesheet data and subtracting the actual from the estimate for each feature then rolling that up to the release level.
I am using PowerPivot measures to get the estimate and the actual.
The estimate is an average because it is stored in the task in the timesheet database.
The actual is a sum of all time booked to that task.
Estimate:=Average([ROMEstimate])
Actual:=Sum([Capital])
Variance:=[Actual]-[Estimate]
This works on the feature level but not the rolled-up release level. I do not want an average there but a sum of the averages below that.
Feature | Estimate | Actual | Variance |
Release | 41 | 55 | 14 |
Feature A | 36 | 8 | -28 |
Feature B | 125 | 16 | -109 |
Feature C | 20 | 4 | -16 |
Feature D | 10 | 3 | -7 |
Feature E | 56 | 24 | -32 |
<tbody>
</tbody>
To avoid the average I did try a separate table with the estimate for each task but could not get that measure to work.
Any ideas?