Using Quick Measures
You may use quick measures for performing common, powerful calculations quickly. Primarily, a quick measure runs a set of Data Analysis Expressions (DAX) commands behind the scenes, and thereby presents the results to use in your report. Also, there is no need to write the Data Analysis Expressions (DAX) commands, since it is done for you based on input provided in a dialog box. It offers many available categories of calculations and ways to modify each calculation to fit your needs. Further, you can view the DAX that’s executed by the quick measure and jump-start with the same.
Steps to create a Quick Measure
- Firstly, right-click or select the ellipsis … next to any item in the Fields pane, then select New quick measure from the menu that appears.
- In the second steps, after selecting New quick measure, the Quick measures window appears, letting you select the calculation you want and the fields to run the calculation against.
- Next, select the Select a calculation field to see a long list of available quick measures.
Quick Measure Calculation
| Quick Measure Calculation Types | Calculations |
| Aggregate per category | Average per category Variance per category Max per category Min per category Weighted average per category |
| Filters | Filtered value Difference from filtered value Percentage difference from filtered value Sales from new customers |
| Time intelligence | Year-to-date total Quarter-to-date total Month-to-date total Year-over-year change Quarter-over-quarter change Month-over-month change Rolling average |
| Totals | Running total Total for category (filters applied) Total for category (filters not applied) |
| Mathematical operations | Addition Subtraction Multiplication Division Percentage difference Correlation coefficient |
| Text | Star rating Concatenated list of values |
Things to keep in mind when using Quick Measure
- Firstly, you can use quick measures added to the Fields pane with any visual in the report.
- Secondly, you can always see the DAX associated with a quick measure by selecting the measure in the Fields list (in the formula bar).
- Thirdly, quick measures are available only if you can modify the model
- Lastly, you can’t create time intelligence quick measures when working in DirectQuery mode.
