Power BI measures: calculations that respond to every filter
Power BI measures are calculations that return a result for whatever a reader has selected in a report. A measure holds a formula, not stored values, so its answer changes as filters and slicers change. Totals, averages, ratios and growth figures all belong in measures. This guide explains how they work, how to create one and how to keep a growing list of them tidy.
- What a measure does
- First measure in four steps
- Tidy folders and names
Last updated
What are Power BI measures and why do reports need them?
A measure calculates a result from a formula. The formula language is DAX, which looks a lot like Excel formulas. However, DAX works over related tables and not over single cells.
Power BI Desktop already creates a simple calculation when you drag a numeric field onto the canvas. It sums the values without being asked. That helps for a quick look, but it stops short of real business questions. A margin, a growth rate or a projected figure needs a measure you write yourself.
The key idea is that a measure has no fixed answer. Its result changes as readers interact with the report. So one sales measure can serve a chart by month, a table by region and a single total.
Three kinds of measure a report author will meet
Microsoft documents several ways to get a measure, and each one suits a different moment.
Model measures
An author writes these in the data model with DAX. They appear in the Data list with a calculator icon, so every report on that model can reuse them.
Quick measures
Desktop offers ready-made calculations that you pick from a dialog. They also help beginners, because the generated DAX formula stays open for review.
Report-level measures
An author adds these inside one report that sits on an existing model or a live connection. As a result, the original model stays untouched.
Power BI measures: create your first one in four steps
The route below follows the Desktop menus that Microsoft describes, and it works the same for simple and complex formulas.
Pick the home table
First select the table that should hold the measure in the Data pane. That home table decides where readers will find it later.
Choose New measure
Then select New measure on the Modeling ribbon. A formula bar opens above the canvas and waits for a name.
Write the formula
Next type a name, an equals sign and the DAX expression. For example, a sum of a sales column makes a sound first attempt.
Test it in a visual
Finally drag the measure into a table next to a category. Check a few rows by hand before anyone else relies on it.
How should a team organize Power BI measures as the list grows?
A model with a handful of calculations needs no structure. A model with a hundred does. Without order, authors write the same formula twice under different names, and then two reports disagree.
Display folders solve most of that. In Model view you select a field and type a folder name in the Properties pane. A backslash in the name creates a subfolder, so finance ratios can sit inside a finance folder.
Some teams also keep a table that contains only measures. You create a one-column table with Enter data, move the measures there and hide the column. That table then appears at the top of the Data pane, where authors look first.
Which habits keep a measure trustworthy over time?
Names matter more than most authors expect. A reader sees the measure name in every visual and every export. So write names in business language, and avoid abbreviations that only the author understands.
Formatting belongs to the measure as well. When you format a result once in the model, every visual inherits it. Microsoft also documents dynamic format strings, which apply a format through a separate DAX expression. That helps when one measure must show different units.
Finally, build complex calculations from simple ones. A margin measure can reference a revenue measure and a cost measure. Then a change to the revenue rule flows through every formula that depends on it.
A short checklist before you publish a new measure
These checks take a few minutes, and they catch most errors before a reader does.
- The name reads as plain business language
- The format suits the unit it reports
- The result matches a hand check on sample rows
- The total row makes sense, not only the detail rows
- Each measure sits in a clear display folder
- No second measure already does the same job
Power BI measures: questions authors ask most
What is the difference between Power BI measures and calculated columns?
A measure calculates a result when a visual asks for it, and the answer depends on the filters in play. A calculated column works out a value for every row of a table and keeps it with the table. So measures suit totals and ratios, while columns suit labels you want to slice or group by.
Where do Power BI measures appear in Desktop?
They appear in the Data list under their home table, marked with a calculator icon. You can create and view them in Report, Table or Model view. Because the home table only controls the location, you can move a measure to another table without changing its result.
Can a Power BI measure return a link?
Yes. Microsoft documents that a measure can build a URL string. You then set its data category to Web URL, and the report shows the result as a link. Because a formula creates the address, the link can adapt to the reader's current selection.
Why can I not see a hidden measure in Excel?
Hidden measures remain visible and usable inside Power BI Desktop. However, Excel and the Power BI service act as client tools, so they do not list hidden fields. If analysts need the calculation in Excel, unhide it or reference it from a visible measure instead.
Can Power BI Agency review the measures in an existing model?
Yes. One of our consultants reads through the model, flags duplicate or conflicting formulas and proposes clear names and folders. The work happens online inside your own Microsoft tenant, with a weekly demo. Power BI Agency is a division of Sataware Technologies and independent of Microsoft. It starts with a free 30-minute assessment.
Let's build your first dashboard together.
Tell us what you report on today. A consultant replies within 2 hours with next steps.
Trusted partners
Microsoft Solutions Partner · AWS Partner
Cloud & AI Platforms
Azure SQL, Microsoft Fabric and the data pipelines behind your reports.
AI Business Solutions
Power BI reporting on your Dynamics 365, Business Central and Power Platform data.
Security
Row-level security and Entra ID sign-in on every report and workspace.
Amazon Web Services
Power BI on your AWS data, with connectors for Redshift, Athena and S3.