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

Oct 15, 2026

Ontology Agent - Ep.572

The Fabric IQ ontology agent can draft an ontology from a lakehouse, and it still cannot finish the job it just offered to do. Tommy Puglia and Mike Carlo hold the preview out of any workspace a client depends on.

Oct 13, 2026

Fabric Notebook Toolkit - Ep.571

Microsoft's Fabric Notebook Toolkit lets an agent you already pay for drive notebooks from a CLI. Tommy Puglia and Mike Carlo treat the preview as a tool to learn, not a pattern to hand to every workspace.

Oct 8, 2026

PADU and Fabric - Ep.570

Tommy Puglia borrows a four-bucket scale from Fatal Risk and asks where Fabric patterns land: preferred, accepted, discouraged, or unacceptable. Mike Carlo keeps the answer tied to the job, not the artifact.