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

Jun 10, 2026

Microsoft Build Recap – Ep.535

Mike and Tommy recap Microsoft Build 2026 through a Power BI and Fabric lens, focusing on the announcements that matter most for report builders, semantic models, and agent-driven app development. They unpack why Rayfin, Replit integration, OneLake, and new Fabric skills signal a shift from asking AI for answers toward using agents to create real production artifacts.

Jun 5, 2026

CI/CD Automation with Agents – Ep.534

Mike and Tommy explore how agents can simplify CI/CD in Fabric by helping teams work through Git workflows, merge conflicts, validation, and deployment automation. They also compare deployment pipelines with Git-based approaches and explain why small, testable automations are the safest way to start.

Jun 3, 2026

Claude Design & Power BI Embedded – Ep.533

Mike and Tommy explore how Claude Design, agentic workflows, and HTML wireframes could reshape report prototyping for Power BI teams. They also debate where today’s tooling still falls short, especially for Power BI Desktop users who need practical ways to turn context, design ideas, and embedded experiences into working reports.