Calculated Measures

A calculated measure is something you can create in pivot tables and charts using arithmetic operations with base measures. For example, you can use the following definition to calculate profit percentages:

% Profit = Est. Gross Profit (Sum) / Amount (Sum)

Formula fields are built at the dataset level and evaluate results row by row, while calculated measures are created at the workbook level using aggregated results. For example, if you create a formula field to calculate sales amounts, each row in the dataset shows a single value based on the formula. If you use that formula field as a measure in a pivot table or chart, the results are simply an aggregate of the formula field values. In contrast, calculated measures use the aggregated results of base measures and arithmetic operations to show results like year-over-year variances and profit percentages. You can't get these types of results using formula fields alone. For more information about the difference between formula fields and calculated measures, see Formula Fields and Calculated Measures.

You can create as many calculated measures as you need using fields from the connected dataset, including custom formula fields. In visualizations based on linked datasets, you can even combine fields from both datasets to make a calculated measure. However, you can only use a calculated measure in the pivot tables or charts where you create it.

To create your calculated measures, see the following:

Related Topics

General Notices