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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.