How to Use Quick Measure in Power BI?

This Power BI tutorial helps you to understand the process of working with quick measure suggestions in Power BI.

I recently worked on a complex Power BI report, and thanks to quick measures, I significantly reduced my development time.

In this article, we will learn about quick measures in Power BI, how to enable it on your Power BI Desktop, and how to use quick measure in Power BI effectively. Additionally, we will see the Power BI rolling average quick measure with an example.

Quick Measure in Power BI

Quick Measures in Power BI are like shortcuts for creating common calculations or aggregations in your data without writing complex DAX formulas. It’s a user-friendly feature that helps you save development time.

Under the Home tab, you see the Quick measure. Check the screenshot below.

Power BI Quick Measure

How to Enable Quick Measure in Power BI

If you don’t see the quick measure option on your Power BI Desktop, follow the steps below:

1. Open Power BI Desktop and select the File tab.

how to enable quick measure suggestions in power bi

2. Click the Options and settings -> Click Options.

what is quick measure in power bi

3. In the Options window, click Preview features -> check the Quick measure suggestions checkbox -> click the OK button.

How to Enable Quick Measure in Power BI

After that, close the Power BI Desktop and reopen it. You should then see the Quick measure option.

Power BI Quick Measure

This way, you can enable the quick measure option in Power BI.

How to Use Quick Measure in Power BI

I will tell you how to use quick measure in Power BI.

Here, I have a SharePoint list (Amazon Go) that contains below columns with various data types:

ColumnsData Types
Order DateDate and time
RegionSingle line of text
Customer NameSingle line of text
Product NameSingle line of text
CategorySingle line of text
Sub-CategorySingle line of text
SalesCurrency
ProfitCurrency
QuantityNumber
quick measure power bi

1. Open Power BI Desktop and load the data. Then, you see data in the Data pane.

quick measure in power bi

2. Under the Home tab, click the Quick measure.

Power BI Quick Measure

3. Then a Quick measure pane opens. Click the Select a calculation dropdown. Then you will see some quick suggestions.

power bi quick measure suggestions

4. Now select Average per category.

how to use quick measure in power bi

5. Using +Add data, add Base value as Sales and Category as Category. Then click Add.

How to Use Quick Measures in Power BI Desktop

6. Then you see the Sales average per Category (Quick measure) added in the Data pane. When selected (Sales average per Category), you can observe the DAX expression in the formula bar.

Sales average per Category = 
AVERAGEX(
	KEEPFILTERS(VALUES('Amazon Go'[Category])),
	CALCULATE(SUM('Amazon Go'[Sales]))
)
How to add quick measures for complex calculations in Power BI

Now we can add any visual in the Power BI report. To do this, follow the below steps.

7. Click the Home tab -> Expand Visual gallery(black box) -> Click the Pie chart.

Creating a quick measure in Power BI

8. Then, using the +Add data option, add the Category into the Legend field and the Sales average per Category into the Values field.

power bi quick measure average per category

You can use the above steps for quick measure suggestions in Power BI Desktop.

Power BI Rolling Average Quick Measure

The example shows how to use rolling average quick measure in Power BI.

1. Under the Home tab, click the Quick measure.

how to use rolling average quick measure in power bi

2. Then a Quick measure pane opens, expand the Select a calculation. Select Rolling average.

how to see quick measure in power bi

3. Add the value to measure and the date. Then, in periods, set your period interval from days, months, quarters, or years. Then set the number of periods before and after. Click Add.

In my case, the Base value is Sales, the Date is Order Date, the Period is Days, the Periods before is 2, and the Periods after is 0.

how to view a quick measure in power bi

4. You can see the Sales rolling average (Quick measure) added to the data pane.

When selected (Sales rolling average), you can observe the DAX expression in the formula bar.

Sales rolling average = 
IF(
	ISFILTERED('Amazon Go'[Order Date]),
	ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
	VAR __LAST_DATE = LASTDATE('Amazon Go'[Order Date].[Date])
	RETURN
		AVERAGEX(
			DATESBETWEEN(
				'Amazon Go'[Order Date].[Date],
				DATEADD(__LAST_DATE, -2, DAY),
				__LAST_DATE
			),
			CALCULATE(SUM('Amazon Go'[Sales]))
		)
)
rolling average quick measure power bi

5. Click the Home tab -> Expand Visual gallery(black box) -> Click the Line and stacked column chart.

power bi rolling average quick measure

6. Then, using the +Add data option, add the Order Date into the X-axis field, Sales into the Column y-axis field, and Sales rolling average into the Line y-axis.

how does quick measure work in power bi

This way, you can use the rolling average quick measure field on your visuals in Power BI.

Conclusion

With the help of Power BI quick measure suggestions, you will reduce your Power BI report creating time.

In this tutorial, we learned what quick measure is in Power BI and how to enable quick measure suggestions in Power BI.

Additionally, we see how to use quick measure in Power BI and Power BI rolling average quick measure.

Moreover, you may like some more Power BI tutorials: