PowerPivot Window: Calculation Area

SQL Server 2012

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

This topic provides Help on the Calculation Area view in the PowerPivot window. For an overview of the user interface and instructions on how to open the PowerPivot window, see Take a Tour of the PowerPivot UI. The Calculation Area enables you to view measures in a grid pattern and to easily create, edit, and manage measures and Key Performance Indicators (KPIs) within the model.

To display the Calculation Area

  1. You must be in Data View. On the Home tab of the PowerPivot window, click Calculation Area in the View area. The Calculation Area appears below the table’s columns, and the Calculation Area button is highlighted and active.

  2. To hide the Calculation Area, click Calculation on the Home tab again so that the Calculation Area button is not highlighted.

To show or hide implicit measures in the Calculation Area

  • In the PowerPivot Window: Advanced Tab, the Show Implicit Measures button is highlighted and active, indicating that all measures, including implicit measures that you create by dragging fields into the Values area in the Field List in Excel, are visible in the Calculation Area. Using the Show Implicit Measures button, you can choose whether to make implicit measures visible in the PowerPivot window. If you hide implicit measures, they are still part of the workbook and can be referenced in DAX formulas, but you will not be able to see them in the Calculation Area.

To change the width of a Calculation Area cell

  1. In Data View, with Calculation Area displayed, point to a white line in between the column headers of a table. Your pointer changes to a double-arrow icon.

  2. Drag the column line to the left or right. The Calculation Area cells under that column also change in width.

To change the height of the Calculation Area view

  1. In Data View, with Calculation Area displayed, point to the dark gray line in between the table columns area and the Calculation Area. Your pointer changes to a double-arrow icon.

  2. Drag the column line up or down. The Calculation Area cells with values appear at the top of the Calculation Area.

    This is helpful if you have many measures to view.

Note Note

The scrollbar always appears on the right side of the Calculation Area because there is a fixed limit of 100 vertical cells in the Calculation Area.

A measure is a formula that is created specifically for use in a PivotTable (or PivotChart) that uses PowerPivot data. Measures can be based on standard aggregation functions, such as COUNT or SUM, or you can define your own formula by using DAX. You can create measures for columns, and the measures appear below the related columns in the Calculation Area. For more information about measures, see Measures in PowerPivot and Create a Measure and KPI (Tutorial).

Note Note

If you create a measure in the Excel window, then the measure will appear below the appropriate column in the Calculation Area of the PowerPivot window when you launch it.

A KPI is based on a specific measure and is designed to help evaluate the current value, status, and trend of a metric. The KPI gauges the performance of the value, defined by a base measure, against a target value. You can extend a base measure to a KPI. For more information about KPIs, see Key Performance Indicators (KPIs) in PowerPivot and Create a Measure and KPI (Tutorial).