Appearance
Quick Calculated Measures
About 575 wordsAbout 2 min
2026-09-03
A quick measure creates an MDX calculated measure from a predefined template. Use it as a starting point for common calculations, then review the generated formula before using it in production.
Choose where to create it
| Scope | Entry point | Availability |
|---|---|---|
| Analysis model | In the model designer, click Create calculated measure and select New quick measure. | Saved with the model and reusable by reports that use the model. |
| Report page | In the report editor's measure selector, click Create calculated measure and select New quick measure. | Saved at page level, shared by components on that page that use the same analysis model, and not added to the model itself. |
Create the measure in the analysis model when the definition should be governed and reused. Create it on a report page for analysis that is specific to that page.

For the model-level workflow and calculated-measure properties, see Measures and Calculated Measures.
Available templates
| Group | Calculations |
|---|---|
| Basic calculation | Addition, Subtraction, Multiplication, Division |
| Comparable period value | Yearly, Quarterly, Monthly, Weekly, and Sequential comparable values |
| Period-over-period change rate | YOY, QOQ, MOM, WOW, and general period-over-period change rates |
| Period-over-period change value | Absolute YOY, QOQ, MOM, WOW, and general period-over-period changes |
| Accumulated | YTD, QTD, MTD, WTD |
| Aggregate per category | Aggregate, Average, Sum, Max, and Min per category; Category correlation; Overall covariance; Sample covariance |
| Percentage calculation | Percentage, Row Percentage, Column Percentage |

Before using a time calculation
Year, quarter, month, week, and accumulated templates require a hierarchy that contains levels configured with the corresponding time level types. If the expected time hierarchy is not available in the quick-measure dialog, correct the time-level configuration in the analysis model first.
Also confirm that the hierarchy order follows the intended drill path, such as Year → Quarter → Month → Day.
For the distinction between Attribute time roles, Measure-level Agent time fields, and model time metadata, see Time Semantics and Default Time Settings.
Create a quick measure
- Open Create calculated measure and select New quick measure.
- Search for or select a calculation template.
- Enter a unique Name.
- Complete the template-specific inputs, such as source measures, time hierarchy, comparison period, or category.
- Select a Format for the result.
- Click Add.
Add becomes available only after a template, a unique name, a format, and all required template inputs are provided.
Check the generated measure
After creation, edit the calculated measure and inspect its generated MDX formula. Confirm at least the following:
- referenced measures match the business definition;
- the time hierarchy and comparison offset are correct;
- the category or aggregation context is correct;
- percentage calculations use the intended denominator;
- the result format matches the value, such as number, currency, or percentage.
Adjust the MDX if the generated definition does not exactly match the required calculation. Save the analysis model for a model-level measure, or save the report for a page-level measure.