Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Kristinfortner
Frequent Visitor

How to sum 2 count columns in Power BI

New to PowerBI.  I have two count columns that I would like to add together and display the results in a card.  When I use the =sumx dax, the count columns are not an option to sum. 

1 ACCEPTED SOLUTION
PaulOlding
Solution Sage
Solution Sage

Hi @Kristinfortner 

The format for SUMX would be something like:

SUMX(TableName, TableName[Column1Name] + TableName[Column2Name])

 

So, the first argument is just the table name, then the calculation you want to do is the 2nd argument.

View solution in original post

2 REPLIES 2
PaulOlding
Solution Sage
Solution Sage

Hi @Kristinfortner 

The format for SUMX would be something like:

SUMX(TableName, TableName[Column1Name] + TableName[Column2Name])

 

So, the first argument is just the table name, then the calculation you want to do is the 2nd argument.

Thank you!

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.