How to Add Total Column in Power BI Table

Adding a total to your table in Power BI seems like it should be a one-click task, but getting it just right often involves a bit more nuance. Whether you need a simple sum at the bottom of a list or a brand new column that calculates a grand total across your rows, there's a straightforward way to get it done. This article will walk you through the different methods, from the easy toggle switch in the user interface to writing a simple DAX formula for more custom calculations.

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

The Quickest Method: Using the Table Visual's Built-in 'Totals' Feature

The simplest way to get a summary is by using the built-in totals feature. This adds a "Total" row to the bottom of your table or matrix, summing up the values in each numeric column. It's perfect for when you just need a quick grand total without any complex logic.

This method works directly on the table or matrix visual itself, meaning you don't have to alter your underlying data model at all. Note that this feature creates a total row, which is often what people mean when asking for a total column - they want the grand total for a specific metric.

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

Step-by-Step Instructions:

1. Create your table: Start by dragging a Table or Matrix visual onto your Power BI report canvas. Add the fields you want to display. For example, you might pull in 'Product Category' from a Products table and 'Sales Amount' from a Sales table.
2. Select the visual: Click on your table to make sure it's selected. The Visualizations pane on the right should become active.
3. Go to 'Format your visual': In the Visualizations pane, click the paintbrush icon to open the formatting options.
4. Find the 'Totals' section: Scroll through the list of formatting options until you find a section named 'Totals'. Expand it by clicking on it.
5. Turn it on: You'll see a simple toggle switch. Click it to turn the totals row on. A new "Total" row will immediately appear at the bottom of your table, providing a sum for each numeric column.

Within this 'Totals' section, you also have a few handy options to customize the look and feel:

• Values: Change the font color, background color, style (bold, italic), and text size of the numbers in your total row. This helps it stand out.
• Label: Customize the text "Total" to something else, like "Grand Total" or "Sum of Sales." You can also format the label's font and color here.

When to use this method: Use this whenever you need a fast, simple grand total summary for your visible data. It's ideal for presentations and high-level dashboards where the main goal is to show a final sum.

Limitations: This 'total' only exists within the visual. You can't reference it in other calculations or use it in other visuals. If you need a total that serves as a building block for more complex analysis, you'll need to use DAX.

How to Add a Custom Total Column with DAX

What if you don't just need a total row at the bottom, but an entirely new column that sums values from other columns? For example, summing quarterly sales figures to get a 'Total Annual Sales' column. For this, you'll need DAX (Data Analysis Expressions).

Don't let the name scare you. DAX is the formula language used by Power BI, and starting with simple sums is easy. For this task, we can either create a Calculated Column or a Measure.

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

Method 1: Using a Calculated Column

A calculated column physically adds a new column to your table in the data model. The calculation is performed row by row and the results are stored in your file, which makes it feel just like a column that came from your original data source. This is great when you need to see the result for each individual row.

Let's use an example. Imagine your table has sales data broken out into four columns: Q1 Sales, Q2 Sales, Q3 Sales, and Q4 Sales.

Step-by-Step Instructions:

1. Navigate to the Data View: In Power BI Desktop, click on the 'Data' icon on the far left (it looks like a small grid).
2. Select your table: From the 'Data' pane on the right, click on the table you want to add the total column to. You'll see your data in a spreadsheet-like view.
3. Create the new column: In the ribbon at the top, under the 'Table Tools' or 'Column Tools' tab, click on "New Column".
4. Write the DAX formula: A formula bar will appear at the top. Here, you'll define your calculation. The structure is Column Name = Formula. For our example, you would type:
5. Press Enter: Hit the Enter key, and your new 'Total Annual Sales' column will appear in the table, with each row showing the sum of the four quarters.

Now you can go back to the 'Report' view and drag this new 'Total Annual Sales' field into your tables and charts just like any other column.

When to use a calculated column: Use it when your calculation depends only on values within the same row (row context) and you want the result to be pre-calculated and stored. It's also useful if you plan to use the new column as a filter or slicer.

Method 2: Using a Measure

A measure is a bit different. Instead of being calculated and stored in your table, a measure is a formula that is calculated on-the-fly based on the context of your report (e.g., filters, selections, and what's in your visual). This is the most common and often most efficient way to create calculations in Power BI.

Using the same quarterly sales example, let's create a measure to achieve the same goal.

Step-by-Step Instructions:

1. Go to the Report View: Click the 'Report' icon on the left (it looks like a bar chart).
2. Create the measure: You can right-click on your table in the 'Data' pane and select "New measure," or you can click the "New measure" button in the Home or Modeling tab of the ribbon.
3. Write the DAX formula: In the formula bar that appears, you'll write a formula to sum up your values. The calculation needs an aggregation function like SUM() because measures operate over many rows. The formula would be:
4. Press Enter: After you press Enter, you won't see a new column in your data view. Instead, you'll see a new field in your 'Data' pane with a small calculator icon next to it. This is your new measure.

You can now use this measure in your visuals. Drag 'Product Category' into a table, and then drag your new 'Total Annual Sales (Measure)' into the same table. Power BI will calculate the sum for each category automatically.

When to use a measure: Almost always! Measures are best practice for aggregating data. They are more flexible, don't increase your file size as much, and recalculate based on user interaction, making your reports dynamic.

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

Troubleshooting and Best Practices

Sometimes your totals might not look right. Here are a few things to check:

• Implicit vs. Explicit Measures: When you drag a numeric field into a visual, Power BI creates an "implicit measure" by picking a default summarization (usually Sum). It's better to create your own "explicit measures" using DAX, like Total Sales = SUM('Sales'[Sales Amount]). This gives you complete control over the calculation.
• Check Your Relationships: If your total is unexpectedly large or small, an incorrect or missing relationship between your tables could be the cause. Check the 'Model' view to ensure your tables are linked correctly.
• Understand Filter Context: Measures are calculated based on the context provided by the visual. If you add a filter or a year slicer, the measure will recalculate for just that selection. Calculated columns, on the other hand, are not affected by this user interactivity on the report canvas.

Final Thoughts

Getting a total in your Power BI table is a fundamental step in data analysis. For a quick visual summary, the 'Totals' switch in the formatting pane is the perfect tool. For more powerful, flexible, and reusable calculations - especially for new columns that sum other columns - learning a little bit of DAX to create measures is the way to go.

We built Graphed because we believe achieving results like this shouldn't require clicking through menus or learning formula languages. Instead of creating measures or formatting visuals by hand, with Graphed you can just connect your data and ask in plain English: "Show me a table of my top product categories by annual sales, and add a column for the yearly total." Graphed instantly builds the interactive visual for you, turning hours of report building into a 30-second conversation.