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

You Are Wasting Your Time! – Ep.531

Stop wasting time in Fabric by identifying inefficient workflows and adopting better practices. Mike and Tommy discuss OneLake storage reporting, Fabric Jumpstart accelerators, and practical ways to speed up your Fabric development.

May 22, 2026

Agentic Skill & Report Design – Ep. 530

Episode 530 explores how agentic coding is reshaping report development, from faster prototyping to new expectations for model and visual design. Mike and Tommy connect the May 2026 Power BI updates to a practical question: which skills still matter most when AI builds more of the stack.

May 20, 2026

AI Driving Your CoE - Ep.529

AI can strengthen a Center of Excellence, but only when it is applied to clear business goals, known pain points, and a defined maturity baseline. Mike and Tommy explain where AI can genuinely reduce friction, where it creates noise, and how teams can prove it is making the COE better rather than just bigger.