One of the PowerPivot advantages is flexibility of changing measure aggregation for instance changing average to minimum. PowerPivot applies default aggregation to a measure and usually it is SUM but in our case SUM does not make any sense so in this tutorial I will show how to change default aggregation to an average and still have flexibility of changing in PivotTable to for instance minimum.