PowerBI.tips

SUM & SUMX Tutorial – Curbal

April 6, 2017 By Mike Carlo
SUM & SUMX Tutorial – Curbal

Learn how to use SUM() and SUMX() with this great video from Curbal. As you become more familiar with PowerBI you will increase your understanding of DAX (Database Analysis Expressions). Microsoft has an extensive list of all the expressions you can use found here.  One of the more common expressions you will use is SUM and SUMX.

Example of SUM, SUMX and Calculate from PowerPivotPro

Microsoft Documentation of SUM

Microsoft Documentation of SUMX

Using the SUMX and SUM expressions:

To learn more about DAX I have read both of these book and found them extremely helpful.  They both cover the basics and then quickly get you understand how to make complex calculations which you will need to make the right visual work.

Curbal has been generating a lot of great content.  To learn about for more information you can visit the website found here, or visit the YouTube Channel.

For more great videos about Power BI click the image below:

PBI Videos

Previous

Dynamic Filters in PowerBI

More Posts

Aug 13, 2026

Fabric as a Backend – Ep.554

Mike has been building apps on Fabric as a backend since January, and he's coining it FAB. The case isn't that you already own Fabric — it's that the workspace identity, git integration, and SQL database remove the wiring you'd otherwise do by hand in Azure.

Aug 11, 2026

Crawl, Walk, Run with AI in PBI – Ep.553

Meagan Longoria's five-stage maturity model for agentic Power BI development gives Mike and Tommy a framework to argue with. They mostly agree — except on the crawl stage, where Mike thinks starting with an MCP server beats starting with a chatbot.

Aug 6, 2026

Power BI Desktop Bridge – Ep.552

Desktop Bridge gives agents a local server to drive Power BI Desktop — reload files, check report state, and take screenshots so the agent can verify its own work. Mike and Tommy agree on the prerequisite: don't use it without skills.