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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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