How to Add Total in Power BI

Updated on:

April 6, 2026

By:

Madhav Bhandari

Use this interactive demo to learn how to add a total calculation to your Power BI reports.

‍

Here’s how to do it:

‍

Open your Power BI desktop and load the report you want to add totals to.
Click on the table visual that needs totals.
In the 'Visualizations' pane on the right, click on the 'Format' icon (paint roller) to access the formatting options.
Scroll down in the formatting menu until you find the 'Totals' section and click to expand it.
Toggle the 'On' switch for 'Totals' to enable sum calculations.
You'll now see totals appear at the bottom of your numeric columns.

📌 Why this matters

Adding totals transforms your data tables from simple row displays into actionable summary views that stakeholders can quickly scan for key figures. Beyond basic addition, totals create visual anchors that help viewers immediately understand scale and proportions within your dataset.

When you present financial reports or performance metrics, totals eliminate the mental math your audience would otherwise need to do, letting them focus on insights rather than calculations. This seemingly small formatting choice often determines whether executives engage with your data or glance past it.

Your product deserves an interactive demo

Start free

How to Uninstall Power BI

How to Compare Two Measures in Power BI

How to Compare Months in Power BI