Quick Measures in Power BI

What if I told you there's no need to write laborious DAX expressions in Power BI? Doesn't that sounds great? I personally enjoy writing the DAX expressions from scratch because it helps to get to know the data well and you can tailor your calculations. But if you don't like writing the DAX expressions from square 1 then you should consider "Quick Measures". Power BI always makes your task easy in visualizing your data and quick measures are something that helps you to create measures in few seconds.

Doesn't that sound amazing? Yeah!! As the name suggests creating measures just by dragging and dropping is an accentuating feature of quick measures. I consider it to be the future of measures in Power BI. In this blog, I will showcase step by step process to create quick measures. I will be working on the Sample Superstore data.

You can find the quick measures right next to the new measure on the top or else you can right-click any of the available table options and you can easily find new quick measures. After selecting the quick measure you will land upon a toggle that will highlight all the measures available for your current dataset.

To start off we will focus on time intelligence functions. If you consider Tableau this is just to drag and drop but in Power BI if you do not use quick measures then you need to write the measure every time. Time intelligence functions help you to get the best out of your date function. Functions such as YTD, MTD, QTD are called time intelligence functions. To create it with the quick measure we will select the YTD in calculation and select the sum of sales and order date from fields respectively.

After that click ok and you will notice that a measure is created in your field and you can expand the measure to see the calculation behind it. Similarly, you can do the same for QTD and MTD calculations.

After digging the time intelligence functions let's move to running total. Running total is sometimes called cumulative total. The process is quite similar to the time intelligence function. After selecting ruuning total in the calculations you need to drag the average of sales and order date.

Suppose you need to look for sales only from the east region. The possible solution is to apply a filter which can be done in quick measures too. You need to select the filter value in calculations and select the sum of sales and region.

There is a pool of options available which can make your life easy and this list of calculations gets update frequently and every time you will get more add-ins calculations.The use of quick measures is a boon as it saves a lot of time while creating a measure. I firmly believe that quick measures will come heftier in the future as compared to measures.

Thanks for Reading Let's connect on LinkedIn.

Comments

Ultimate Beginners Guide to DAX Studio

There are zillions of external tools available with Power BI but DAX Studio is one of the most commonly used tools to work with DAX queries. It is a perfect tool to optimize the DAX and the data model. In this blog let's shed some light on the basic functionalities that can take your report to the next level. ARE YOU READY? To start you will need the latest version of the DAX Studio. You can download it from their website . Don't worry you don't have to pay for the license. Fortunately, DAX Studio is a free tool As a BI Developer, I am using DAX Studio regularly. Based on my experience I use it for several purposes but in this blog, I will highlight the most common ones. Extracting a dump of all the measures used in your PBIX. Why do we need to do this? It can be used for documentation purposes also sometimes we try to reuse the DAX and such a dump comes in handy in this scenario. How to achieve it? Open the DAX Studio it is located under the external tools once you open t

Append v/s Merge in Power BI

Let's discuss another problem of the week. As a Power BI user, there are times when you want to combine queries. What are the ways to do so? In most cases, you can attain it by using either append or merge and both serve different purposes. Let's understand what do these terms mean in Power BI and how they are functionally different from each other. It is quite common to get data from various sources and you need to combine those data depending on a particular column which is common in both tables so that you can add extra information or column to your big table. In such cases, we use merge queries. How to perform merge queries? For instance, I am considering Sample Superstore data and we will merge the returns table to the order table. You will find both merge and append in the home tab in extreme right in the power query editor. ProTip - You will find two options when you click on the drop-down in merge which are merge queries and merge queries as new. When you use merge que

Use Relationship in DAX

Data modeling is an essential part of creating perfect visuals. While creating complex data models there can be a case where you can find an inactive relationship represented by dotted lines and it occurs because you already have an active relationship between the two tables. But as a developer, you need to use both the relationship. How can it be done? You can use "Use Relationship" in such cases. Use relationship can be added to your DAX and act as a modifier or enhancer for calculation. It activates the inactive relation. But make sure you have an inactive relationship in place before using the use relationship function. Let's see how it works on Sample Superstore data. In my fact table I have two dates- Order date and Ship date. I am making the two relations between my date table and fact table. The relation between the sample superstore (date) to date table (date) is active while the relation between the sample superstore (ship date) to date table (date) is inactive

Analyst in Action

Search This Blog