What is an Expression in Power BI?

Expressions are the backbone of your analytics in Power BI, turning your raw data into meaningful business metrics. Think of them as the recipes you write to tell Power BI exactly how to calculate, filter, and aggregate your information. This article will show you what expressions are, how they work using DAX (Data Analysis Expressions), and how you can use them to create powerful calculated columns and dynamic measures.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is DAX? The Language Behind Power BI Expressions

You can't talk about expressions in Power BI without mentioning DAX. DAX, which stands for Data Analysis Expressions, is the formal name for the language you use to write expressions in Power BI, SQL Server Analysis Services, and even Power Pivot in Excel. If you've ever written a formula in Excel like =SUM(A1:A10), you're already familiar with the basic concept of an expression.

DAX takes that concept to the next level. It's a library of hundreds of functions, operators, and constants that can be combined to perform calculations and create business logic on top of your data model. While an Excel formula crunches numbers in cells on a single sheet, a DAX expression can navigate complex relationships between multiple tables, perform calculations over time, and respond dynamically to user selections in your report.

Essentially, every time you want to create a new piece of information that doesn’t already exist as a column in your tables - like calculating profit margin, year-over-year revenue growth, or the number of new customers this quarter - you will write a DAX expression to do it.

The Anatomy of a DAX Expression

DAX formulas look intimidating at first, but they follow a clear and consistent syntax. Once you understand the building blocks, you can read and write even complex expressions. Let's break down a fundamental example: creating a measure to calculate total sales.

Total Sales = SUM(Sales[Revenue])

This simple expression has four key components:

• Measure Name (Total Sales): This is the name you are giving your new calculation. It's how the calculation will be identified in your Power BI fields list and on visuals.
• The Equals Sign (=): This is an operator that tells Power BI that what follows is the formula for the measure (or column) you are defining.
• DAX Function (SUM): Functions are predefined formulas that perform specific actions on the data you provide. In this case, SUM adds up all the numbers in a given column. DAX has a huge library of functions for everything from simple math (AVERAGE, MIN, MAX) to sophisticated date calculations (DATESYTD) and logical evaluations (IF).
• Table and Column Reference (Sales[Revenue]): This tells the SUM function which numbers to add up. The syntax is always 'TableName'[ColumnName]. You specify the table name ("Sales") followed by the column name ("Revenue") in square brackets. Using the full table-and-column name keeps your formulas unambiguous, even if you have a "Revenue" column in multiple tables.

As you build more complex expressions, you'll also use other operators, like mathematical operators (+, -, *, /) and logical operators (&&, ||, =, >, <).

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Where Exactly Do You Write Expressions in Power BI?

You can use DAX expressions in several places within Power BI to achieve different goals. Understanding where to use them is just as important as knowing how to write them. The three main places are Calculated Columns, Measures, and Calculated Tables.

1. Calculated Columns

A calculated column is a new column that you add directly to one of your existing tables. The expression for a calculated column evaluates its formula for each row in that table and stores the result. Think of it as a permanent post-it note on every single row.

When to use a calculated column:

• When the calculation depends only on other data from the same row.
• When you want the result to be "static" - it's calculated once when the data is refreshed and doesn’t change based on your report filters.
• When you need to use the result as a slicer, filter, or axis on a chart.

Example: Calculating Profit per Sale

Imagine you have a 'Sales' table with columns for [ListPrice] and [StandardCost]. You can create a calculated column for [Profit] like this:

Profit = Sales[ListPrice] - Sales[StandardCost]

When you create this, Power BI will go through your 'Sales' table row-by-row, perform the subtraction for each transaction, and save the result in the new 'Profit' column. That value won't change unless the ListPrice or StandardCost for that row changes during the next data refresh.

2. Measures

Measures are arguably the most powerful feature of Power BI, and they exist almost entirely as expressions. Unlike calculated columns, measures don’t store any values directly in your tables. Instead, they perform a calculation on-the-fly based on the context provided by your visuals, filters, and slicers in a report.

When to use a measure:

• When the calculation needs to be dynamic and change based on user interactions.
• When you want to calculate an aggregate value, such as a sum, average, count, or percentage (e.g., Total Revenue, Average Order Value).
• Most of your business logic calculations belong in measures!

Example: Calculating Total Revenue

Our opening example, Total Sales = SUM(Sales[Revenue]), is a perfect measure. If you put this measure on a card visual, it will show the grand total revenue. If you put it on a bar chart that displays data by country, the same measure will automatically calculate the revenue for each specific country. If the user then filters for the year 2023, the measure recalculates again to show just the 2023 revenue. It constantly adapts.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

3. Calculated Tables

Less common, but still incredibly useful, you can use a DAX expression to create an entirely new table in your data model. This is often used for creating supporting tables that help with analysis, like a dedicated date table.

Example: Creating a Calendar Table

You can generate a table containing a column of every single date between two years using a single expression:

Dates = CALENDAR(DATE(2023, 1, 1), DATE(2024, 12, 31))

This formula creates a new table named "Dates" with a single column containing all dates from January 1, 2023, to December 31, 2024. You can then connect this table to your sales or orders data to enable powerful time-based analysis.

How to Write Your First Expressions: Step-by-Step Examples

Let's walk through creating a simple calculated column and a few measures to see this in practice.

Example 1: Create a "Discount Amount" Calculated Column

Imagine a 'Sales' table with columns for [OrderQuantity], [UnitPrice], and [UnitPriceDiscount]. We want to create a column that shows the total dollar value of the discount for each transaction.

1. Click on the Data view icon (it looks like a small grid) in the left-hand pane of Power BI.
2. Select your 'Sales' table from the Data pane on the right.
3. From the Table Tools tab in the ribbon at the top, click on New column.
4. A formula bar appears. Enter the following DAX expression:

Discount Amount = (Sales[UnitPrice] * Sales[OrderQuantity]) * Sales[UnitPriceDiscount]

When you press Enter, a new "Discount Amount" column appears in your table, with a value calculated and stored for every single row.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Example 2: Create a Basic "Average Price" Measure

Now let's create a dynamic measure to calculate the average unit price across all transactions. This will update based on filters and selections in our report.

1. Click on the Report view icon (the bar chart icon in Power BI's left pane).
2. In the Data pane on the right, right-click on the 'Sales' table and select New measure.
3. In the formula bar, type the following expression:

Average Unit Price = AVERAGE(Sales[UnitPrice])

1. Press Enter. A new measure with a small calculator icon appears in your table. To see it work, add a Card visual to your report canvas and drag your Average Unit Price measure onto it.

Example 3: Create a More Sophisticated Measure with CALCULATE

The CALCULATE function is the most important function in DAX. It allows you to modify the filter context of a calculation. Let's create a measure that calculates the total sales but only for products that are the color "Red."

1. Right-click on your 'Sales' table and select New measure.
2. Enter the expression below. As you type, notice how Power BI's IntelliSense feature helps you find the correct function and table/column names.

Red Product Sales = CALCULATE( SUM(Sales[SalesAmount]), 'Product'[Color] = "Red" )

Here, the first part is our expression to sum sales. The second part is a filter that tells CALCULATE to only sum sales where the 'Color' column in the related 'Product' table is "Red." No matter where you use this measure in your report, it will always show you the sales for red products only.

Tips for Writing Better Expressions

• Formatting Matters: For complex formulas, use SHIFT + ENTER to add line breaks and tabs to indent your code. This makes them much easier for you and your colleagues to read.
• Add Comments: You can add clarifying notes to your DAX expressions by starting a line with a double hyphen -- or a double slash //. This is a lifesaver when you return to a complex formula months later.
• Explicitly Name Tables: Always get in the habit of including the table name before the column name (e.g., SUM(Sales[Revenue]) instead of SUM([Revenue])). This prevents errors and makes your formulas easier to understand.
• Master CALCULATE: Invest time learning the ins and outs of the CALCULATE function. It is the key to unlocking an enormous amount of analytic power in Power BI.

Final Thoughts

At its core, a Power BI expression is simply a command you write using the DAX language to create new insights from your data. Whether you're making a calculated column for row-by-row logic or a dynamic measure that slices and dices data in real-time, expressions are the engine that drives your Power BI reports from simple charts to valuable analytical tools.

Writing DAX can have a steep learning curve, which is perfect for full-time data analysts but a major hurdle for marketers, founders, and sales teams who just need answers. We built Graphed because we believe getting insights from your business data shouldn't require learning a new query language. We connect to an ever-growing list of tools like Google Analytics, Shopify, and Salesforce, allowing you to ask questions in plain English, and our AI data analyst builds real-time, interactive dashboards for you in seconds - no expressions required.