PowerPivot Nuggets - Part 12 - The Measure Grid

In PowerPivot v1 calculated columns were created in the PowerPivot window and calculated measures were created in the PowerPivot Field list interface in Excel. In v2 you can now also create calculated measures in the PowerPivot window by using the new measure grid.



You cannot only create measures in the measure grid, but PowerPivot will actually calculate the measure. Another cool thing is the fact that the measure is recalculated when you start filtering the table, as you can see in the screenshot below (filtered on Clothing).