How to Get Measure Tools in Power BI

If you're looking for a single "Measure Tools" button in Power BI, you might have a hard time finding it - because it doesn't really exist as a standalone feature. Instead, Power BI offers a powerful set of capabilities for creating and managing measures, primarily through a language called DAX. This article will show you where to find these tools, how to use them to create powerful dynamic calculations, and why they are the key to unlocking truly insightful reports.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly Are Measures in Power BI?

Before diving into the "how," it's important to understand the "what." In Power BI, a measure is a formula that performs a calculation on your data. The key thing to remember is that a measure's result is dynamic and changes based on the context of your report - like filters, slicers, or interactions with charts.

Think of it this way: if you have a sales table, adding a calculated column to multiply Quantity by Price for each row gives you a static Line Total. This value is calculated once when the data is refreshed and stored in the table.

A measure, on the other hand, calculates an aggregation on the fly. For example, a [Total Sales] measure would use the SUM() function. When you place this measure on a card visual, it shows the sum for all sales. If you add a "Year" slicer to your report and select "2023," the [Total Sales] measure instantly recalculates and shows you the total sales for only 2023. It respects the context you give it.

Measures are the backbone of Power BI analysis because they allow you to perform aggregations and create key performance indicators (KPIs) like:

• Total Revenue or Profit
• Average Order Value
• Year-over-Year Growth Percentage
• Customer Count

Finding and Using Power BI's Measure Tools

While there isn't a dedicated "Measure Tools" menu, the relevant features are found within the Power BI Desktop interface, primarily in the Report View. There are two primary ways to create a new measure.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Using the Ribbon

This is the most direct method for creating a measure.

1. Navigate to the Report View in Power BI Desktop.
2. Select the Modeling tab in the top ribbon.
3. Click on the New Measure icon.

When you click this, Power BI will activate the formula bar just below the ribbon, ready for you to enter your DAX formula.

Method 2: Using the Data Pane

This method is also very common and allows you to associate the measure with a specific table from the start.

1. In the Data pane on the right-hand side, find the table where you want your measure to reside.
2. Right-click on the table name (or any column within it).
3. Select New Measure from the context menu.

Just like the first method, this will bring up the formula bar where you can write your calculation.

Creating Your First Measure: A Step-by-Step Example

Let’s walk through a tangible example. Imagine you have a simple Sales table with the columns Product, Units Sold, and Price Per Unit. Our goal is to create a dynamic measure for total revenue.

Step 1: Create the New Measure

Using either of the methods above, click New Measure. Let’s create this in our Sales table. You'll see this in the formula bar:

Measure =

Step 2: Write the DAX Formula

DAX, or Data Analysis Expressions, is the formula language used in Power BI. It might look intimidating, but basic calculations are very similar to Excel.

We need to calculate revenue row by row (Units Sold * Price Per Unit) and then sum it all up. For this, the SUMX function is perfect. Replace Measure = with the following:

Total Revenue = SUMX('Sales', 'Sales'[Units Sold] * 'Sales'[Price Per Unit])

Here’s a quick breakdown of the formula:

• Total Revenue = This is the name we are giving our new measure.
• SUMX(...) is an "iterator" function. It goes through a table (Sales, in this case) row by row and performs a calculation. After it has finished the calculation for all rows in the current context, it sums up the results.
• 'Sales'[Units Sold] * 'Sales'[Price Per Unit] is the expression it calculates for each row.

Hit Enter or click the checkmark to commit the formula.

Step 3: Format Your Measure

Once you commit the formula, your new measure will appear in the Sales table in the Data pane, usually with a small calculator icon next to it. Now, if you select the measure, a new contextual tab appears in the ribbon called Measure tools. This is where you finalize and format your work!

In the Measure tools tab, you can configure:

• Measure name: You can rename your measure here if you wish.
• Home table: You can move the measure to a different table to keep your model organized (more on this later).
• Formatting: This is critical for usability. For our Total Revenue measure, you can:

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Use Your Measure in a Visual

Now for the fun part. Drag your freshly formatted [Total Revenue] measure from the Data pane onto your report canvas. Power BI will automatically create a column chart or card visual. You can also drag it into an existing visual to add it to a table, chart, or matrix. The values you see will update automatically as you slice and dice your data.

Essential Measure Concepts and Techniques

Once you’ve mastered the basics, you can move on to more powerful techniques that professional analysts use daily.

Explicit vs. Implicit Measures

What we just created is an explicit measure - a calculation we defined ourselves with DAX. An implicit measure is what happens when you drag a numeric column (like Units Sold) directly into a visual. Power BI will automatically apply a simple aggregation like Sum, Average, or Count.

You should always favor explicit measures. They are reusable, centrally managed, and can be used in other, more complex calculations. Implicit measures are convenient for a quick look but are messy and inflexible for building scalable reports.

Unlock Power with the CALCULATE Function

If there's one DAX function you need to learn, it’s CALCULATE. It's often described as the most powerful function in DAX because it allows you to modify the filter context of a calculation.

The basic syntax is CALCULATE(<Expression>, <Filter1>, <Filter2>, ...).

Let's say you want to see the total revenue but only for a specific product, like "Laptops". You can create a new measure:

Laptop Revenue = CALCULATE([Total Revenue], 'Sales'[Product] = "Laptop")

This measure takes our existing [Total Revenue] calculation but applies its own filter on top of the report's context, making it extremely useful for comparative analysis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Use Quick Measures for Faster Development

Don't want to get lost in complex DAX? Power BI has a feature to help. Quick Measures is a wizard-like interface that builds the DAX formula for you based on your inputs.

You can find it on the Home tab of the ribbon. Simply click New quick measure, select a calculation from the dropdown (like Year-over-year change, running total, or weighted average), and then drag the required fields into the boxes. Power BI generates the often-complex DAX code, which is a fantastic way to both save time and learn how DAX works.

Best Practice: Use a Measure Table

As you build more measures, your data tables can become cluttered, mixing your raw data columns with your calculations. To solve this, analysts use a common trick: a dedicated "Measure Table." This is a table that contains only measures.

1. On the Home ribbon, click Enter Data.
2. A single blank column is created. You can leave it as is or rename it. Then, name the table something like _Key Measures (the underscore ensures it appears at the top of your table list). Click Load without adding any rows.
3. Now, click on each measure you've created. Using the Measure tools tab, change the Home table for each measure to your new _Key Measures table.
4. Once all your measures are moved, right-click on the original dummy column in _Key Measures (Column1) in the Data pane and select Hide.

The empty table will now disappear from the table list and reappear at the top with a calculator icon, acting as a neat little folder for all your important calculations, making your model clean and easy for others to navigate.

Final Thoughts

Mastering measures is fundamental to leveling up your Power BI skills. By understanding how to create, format, and organize measures using DAX, you transform Power BI from a simple charting tool into a dynamic analysis platform capable of supporting powerful business decisions. Start with simple SUMs and averages, explore Quick Measures, and don't be afraid to try using CALCULATE to see how it can alter a report's context.

We know that learning DAX and navigating Power BI’s interface can demand a significant time investment just to get the answers you need. At Graphed, we've designed a totally different approach. You can simply connect your data sources, and then ask questions in plain English - like "What was my total revenue broken down by product last quarter?" - and Graphed instantly builds the live, interactive visualizations for you. There's no DAX to learn and no toolbars to hunt for, just clear, immediate insights so you can get back to growing your business.