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

May 15, 2026

Importance of Skills for the Fabric Developer - Ep.528

In this episode, Mike and Tommy dig into why building the right skills matters for Fabric developers and how that thinking changes what you learn first. They also discuss how to evaluate skill depth, avoid tool-chasing, and create a plan for steady growth.

May 13, 2026

Semantics Layer Genie & Data Agents - Ep.527

Mike and Tommy explore what ‘semantic layer genies’ and data agents could mean for Fabric and Power BI teams, from metadata-driven modeling to assisted development workflows. They break down where agents help today, what needs governance, and how to stay practical as the hype accelerates.

May 8, 2026

Stop Using Bookmarks - Ep.526 - Power BI tips

In Episode 526 of Explicit Measures, Mike Carlo and Tommy Puglia unpack the latest Power BI and Microsoft Fabric topics from the show. You’ll get a quick read on the episode’s biggest ideas, why they matter, and where to dig deeper in the full conversation.