Measures in Power BI

Updated on January 2, 2024
Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

Measures in Power BI are a summarization of any data. So, it is important to have a summary of any data or representation of data. Although in Power BI, we have tools to create our measures based on the data itself. We also have the option to name the measures in the way we want.

What are Measures in Power BI?

Power BI measures are the way of defining calculations in a DAX model, which helps us to calculate values based on each row. But rather, it gives us aggregate values from multiple rows from a table. Creating Power BI measures is often called “calculated measures,” which use DAX expressions to calculate new values from the existing table.

measures-in-power-bi

You are free to use this image on your website, templates, etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Measures in Power BI (wallstreetmojo.com)

Now, we will see how we can create new measures in Power BI to play with the existing data set. You can download the workbook used in this example to practice with us.

You can download this Measures in Power BI Excel Template here – Measures in Power BI Excel Template

–>> If you want to learn Power BI professionally, then Power BI Basics Course (5+ hours) is the perfect solution. This course will introduce you to a wide range of Power BI concepts like collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights, Creating Reports in Power BI Desktop, Analyze Data with Excel, Graphs & Visualizations, Interactive Dashboards along with some real life examples.

How to Create & Use Measures in Power BI?

We have already uploaded the data to Power BI, and the table has different columns, as shown below.

measures in power bi (Data)

From this table, we do not have the “Total Sales” value to calculate the total sales value. However, we can insert the calculated column to calculate total sales.

  • To add a new column, right-click on the table and choose “New Column” under the “Fields” section, as shown below.
New Column
  • It will open up a new column section in the “Formula Tab.”
measures in power bi (New Column - formula tab).png
  • First, we need to give the column a name before we apply the DAX expression formula. Give the name as “Total Sales” and enter the formula as shown below.
measures in power bi (total sales)
  • After the above formula, press the “Enter” key. We will have a new column in the table.
total sales
measures in power bi (gross profit)
  • Below is for Gross Profit % (GP%).
measures in power bi (gross profit%)
  • Now, using these new columns, we can create “New Measures” to get the aggregate total values. Right-click on the table and choose “New measure.”
New Measure
  • It will also create a new column similar to the above, but we could see the word “Measure.”
measures in power bi (measure - formula tab)
  • Now, if you want to get the amount of the overall sales, we can create that Power BI measure by using DAX expressions. But, first, give a name to the measure as “Overall Sales” and open the SUM DX function.
measures in power bi (Sum)
  • As you can see above, the IntelliSense list started to show all the columns from the table. So, choose “TV_Sales[Total Sales].”
measures in power bi (sum total sales)
  • Close the bracket and press the “Enter” key to get the new measure in the table.
Overall Sales
  • Similarly, get the Gross Profit (GP) overall summary value in the new Power BI measure.
measure power bi (Overall Sales GP)
  • Now, let us create one more new measure in Power BI to get the overall sales value against all the cities. For this, we need to use DAX functions and first open up the new measure.
measure power bi (Overall City sales)
  • Before starting the DAX formula, you can insert a comment for this function by starting with two forward slashes.
measure power bi (Overall City sales formula)
  • In the next line, you can continue the formula to jump to the next line and press the “Enter” key by holding the “ALT” key together.
measure power bi (Overall City sales formula new line)
  • Open the CALCULATE function.
measure power bi (Overall City sales Calculate)
measure power bi (Overall City sales Calculate Sum)
  • For the SUM function, choose the “Total Sales” column.
measure power bi (Overall City sales Calculate Sum Total Sales)
  • The second argument is Filter 1 for this open ALL function.
measure power bi (Overall City sales Calculate Sum Total Sales, ALL)
  • For this supply, select the “City” column.
measure power bi (Overall City sales Calculate Sum Total Sales, ALL, city)
  • Close two brackets and press the “Enter” key to get this new Power BI measure.
  • Using these measures, we can calculate each city’s contribution percentage. Enter the new measure column and name it “Sales %.”
measure power bi (Sales %)
  • To calculate “Sales %,” enter the formula “Overall Sales / All-City Sales * 100”.
measure power bi (Sales %, overall sales)
  • Press the “Enter” key to finish the formula.
  • Using these new measures, we will build a table to show each city’s sales percentage. Insert “Table” visual from visuals.
Table Card
  • Now, drag and drop “City,” “Overall Sales,” “Overall City Sales,” and “Sales %” to the “Values” field of the “Table” visual.
Drag & Drop in VAlues

It should have created a visual of city-wise sales with their overall city-wise contribution.

Visual of City Wise Sales

Now, we can see Ahmedabad city has contributed 17.69 % to the overall sales value. So, using measures in Power BI, we can get the new values using DAX formulas.

Note: We can also download the Power BI dashboard file from the link below and view the final output.

You can download this Power Bi Measures Template here – Power Bi Measures Template

Things to Remember Here

  • Calculated columns and calculated measures are different from each other.
  • Using measures, we can create aggregate totals.
  • Almost all the measures in Power BI are created with the help of DAX formulas.
  • Usually, all the measures are stored in a separate table for a better understanding of the measures.

Recommended Articles

This article is a guide to Measures in Power BI. Here, we will learn how to create and use new measures to play with the existing data set in Power BI, along with examples and explanations. You can learn more about data visualization from the following articles: –