Using Quick Measures

  1. Home
  2. 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 TypesCalculations
Aggregate per categoryAverage per category
Variance per category
Max per category
Min per category
Weighted average per category
FiltersFiltered value
Difference from filtered value
Percentage difference from filtered value
Sales from new customers
Time intelligenceYear-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
TotalsRunning total
Total for category (filters applied)
Total for category (filters not applied)
Mathematical operationsAddition
Subtraction
Multiplication
Division
Percentage difference
Correlation coefficient
TextStar 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.
Microsoft Exam DA-100 Free Practice Test
Menu