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

Sep 24, 2026

Agentic Dev of PBI Reports – Ep.566

Kurt Buhler tells Tommy Puglia and Mike Carlo that a full Power BI report from an agent went from a bad idea to a half-hour build in the span of a week. The catch, in his telling, is the report format, the context you bring, and a requirements process that now has to scale past a single page.

Sep 22, 2026

Your Identity and Power BI – Ep.565

Tommy Puglia, Mike Carlo, and Kurt Buhler spend this episode on what is left of the Power BI identity once Microsoft Fabric and agents are part of the job. The skill that still decides the work is judgment: listening to the business, and staying critical of what an agent hands back.

Sep 17, 2026

Self Aware in Data and AI Literacy – Ep.564

Power Query is moving a set of cloud connectors from ODBC to ADBC, and legacy Power BI Q&A now stays through February 2027. Kurt Buhler joins Tommy Puglia and Mike Carlo to sort out what data literacy and AI literacy require once Microsoft Fabric and agents make it easy to build faster than a team can review.