PowerBI.tips

SUM & SUMX Tutorial – Curbal

April 6, 2017 By Mike Carlo
Building Reports
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

#power-bi

Previous

Dynamic Filters in PowerBI

Next

Power BI May 2017 Release

More Posts

Mar 25, 2026

Git Best Practices Diff Noise & Naming - Ep. 513

Mike and Tommy break down the Git habits that make pull requests easier to review, cleaner to merge, and less painful to maintain over time. If your team fights diff noise, inconsistent naming, and mystery changes buried in commits, this episode gives you a practical framework for cleaning that up.

Mar 20, 2026

Publish to Web vs. Embedded - Ep. 512

Mike and Tommy break down the real difference between Publish to Web and Power BI Embedded, and why mixing them up creates security and governance headaches fast. If you need to share reports outside your organization, this episode gives you the practical framework for choosing the right option without accidentally turning convenience into a data leak.

Mar 18, 2026

Scaling a Power BI Side Hustle - Ep. 511

Mike and Tommy break down what it actually takes to grow a Power BI side hustle from occasional freelance work into a repeatable consulting engine. If you're balancing client delivery, productized offers, and the reality of limited time, this episode gives you a sharper playbook for scaling without creating chaos.