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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
Solved! Go to Solution.
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.
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!
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!