Quick Measures

Quick Measures

Using quick measures for time intelligence

When to use

Quick measures are handy patterns that you can use to quickly create complex DAX patterns that you may not be able to write on your own

Instructions

Before you create a quick measure:

• Create a basic measure to aggregate your data (SUM, COUNT, etc…)

Creating quick measures:

• Right-click your measure in the Fields window > New Quick Measure
• Choose your measure pattern
• Configure as desired

Example: Year to date Sales based on the Sales[Amount] column:

• Create a basic measure:  Sales $= SUM(Sales[Amount])
• Right-click the [Sales $] measure > Quick Measures
• Select Time Intelligence > Year-to-date total
• Set the Base Value to [Sales $]
• Set the Date to Calendar[Date]
• Use the measure on a visual

Hints & tips

• Always base your quick measures on explicit measures
• Once created, Quick Measures can be edited like any other measure
  • Rename by right-clicking the measure in the Field list > Rename
  • Change formats by selecting the measure in the Field list > Modeling > change the formatting