Quick Measures – How To Use Them In Power BI Models

by | Business Intelligence, Power BI

Quick measures in Power BI is a fantastic feature that can increase the speed of development immensely. You may watch the full video of this tutorial at the bottom of this blog.

Here, I review how you can start using them and I look at the many considerations of actually implementing them.

Reminder About Quick Measures In Power BI

Before we dive into some examples, let me just give you a friendly reminder that while it is very easy to use, Quick measures isn’t perfect. But the good news is that it’s being updated all the time.

The Power BI team have made a brilliant decision of wanting to automate as much of the development around Power BI models as possible which is great.

I will touch on the things that you need to be aware of in this article.

Having said that, let’s start working on our first example.

Example #1: Creating Total Sales For Export Measure

Some of you may have already turned on the Quick measures while some haven’t. So let’s start with turning on this feature.

1. Turn on Quick measures

a. To do this, we need to click File then Options and settings, and then Options.

turning on quick measures feature in Power BI-step 1

b. This Preview features pop up box will then appear. All you need to do is to ensure that the Quick measures feature is turned on. After that, just click OK.

turning on quick measures feature in Power BI-step 2

2. Creating A Total Sales For Export Measure

Now that our Quick measure feature is turned on, we’ll have the Quick measure option.

a. So after clicking Total Sales, we will then select Quick measures.

selecting quick measures

b. This pop up box will appear from where we can choose all the different things that we want to create.

quick measures pop up box 1

c. Let’s create a Filtered value, say, Export Sales.

What we need to do is to find where export sales comes in. It’s from the channel column so let’s drag this into the designated box on the left.

quick measures pop up box 2

d. We will then have these selections. For this particular demo, let’s select Export.

quick measures pop up box 3

Now we have our Total Sales for Export.

total sales for export measure

It has also written the formula for us which is really convenient. And you’ll notice that the naming conventions actually work. It has named our measure effectively.

total sales for export formula

But aside from that, the quick measures feature in Power BI also created the filters such as Customer, Dates, Products and so on.

filters created

Let’s say we want to analyze Sales per Customer then Total Sales and then compare that to Export Sales.

filters selected for first example

All of these will then appear in our table.

11

Example #2: Time Intelligence Measures

Let’s look at some of the other Quick measures. For instance, let’s do some time intelligence.

Remember that the Quick measures feature is already turned on so we’ll skip that step.

1. What we’ll do first now is go directly to Quick measures. You’ll see here that we have some time intelligence. We got Year-to-date, Quarter-to-date, Month-to-date, Year over year change, etc.

quarter to date total

2. Let’s select Quarter-to-date. We need a date column so let’s drag that into the box on the left. It then becomes part of the date table that we have.

drag and drop dates

3. You’ll notice that we now have Total Sales QTD. If I drag that into the canvas, you’ll see that this now is calculating but the date is still presented by year.

Total Sales QTD

4. We just need to click on the arrow in the upper left corner so that it’s presented by month. Then we need to click the dots in the upper right corner and click Sort By Total Sales QTD.

Sort By Total Sales QTD

Now that’s actually calculating quarterly.

Total Sales QTD sorted by month

You’ll notice that it’s actually calculating quarterly a cumulative total.

Limitations Of Time Intelligence

Time intelligence, however, has some limitations here.

It actually only works over the hierarchy. If you look at the highlighted portion in the image below, Date Hierarchy is selected.

working only if date hierarchy is selected

If  we change this to date, what will happen is we’re going to get an error.

selecting date
error as a result of selecting date

In my opinion, this is quite restrictive.

We have so many options in our date table. We have month and year, quarter and year, day of the week, and many others.

options in the date table

However, they don’t actually work because the calculation only works over a date hierarchy.

For instance, take a look at this formula below. As you can see, we have ISFILTERED but then we get an error as shown in the highlighted portion.  So it’s not going to return a result.

error in the formula

As I have mentioned earlier, Quick measures isn’t perfect but Microsoft is updating it all the time. Perhaps later on they will attempt to fix this limitation.

Importance Of DAX

Quick measures are seriously awesome, don’t get me wrong, BUT you will still need to have a good understanding of how DAX works and how measures work alongside the data models that you build.

Some of the measures that get created are quite complex and just placing those into your calculations without understanding what is going on is not something that I would recommend.

Conclusion

Quick measures in Power BI can effectively reduce the time you need to work on a model development.

You just need to choose the measures that you want to create and they will be available for you. The formula is also automatically created following the correct naming conventions.

But as we have seen, it also has some limitations like the problem we encountered when working on time intelligence. Aside from this, knowledge of DAX is still necessary to be able to understand what you are coming up with.

Nevertheless, Quick measures are something that can make your process easier.

Good luck with implementing these in your own Power BI models!

Sam

Related Posts

DAX Table Functions Deep Dive

DAX Table Functions Deep Dive

Explore an in-depth analysis of DAX table functions in Power BI, comparing SUMMARIZE and ADDCOLUMNS, and understanding INTERSECT and EXCEPT for enhanced data manipulation and analysis.