How to Sum in Power BI
- George Apostolov
How to Sum in Power BI: step-by-step guide
Click on the visual and go to the 'Modelling' tab.
Select 'New measures' from the 'Modelling' tab.
Type the DAX code in the bar and select 'Sum'.
Select the column name.
Click on the check icon to commit.
Now you can use a measure in any visual to sum up in Power BI.
Quick answer: To sum data in Power BI, select a visual, go to the Modelling tab, and choose New measures. Type the DAX code and select Sum followed by the column name. Click the check icon to commit the measure, which can then be used in any visual.
About this Power BI tutorial
Calculate totals in Power BI by creating a new measure with DAX code and selecting the column to sum for your reports. This guide shows how to sum in Power BI in 6 steps, starting with "Click on the visual and go to the 'Modelling' tab" and finishing with "Now you can use a measure in any visual to sum up in Power BI". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to sum in Power BI?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Summarize Data in Power BI, How to Transfer Power BI Reports to PowerPoint and How to Treat Power BI as a PPT. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
