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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
epelton
Helper I
Helper I

Sum and total per row for calculated column

I am trying to sum 3 columns. This DAX for a calculated column sums all rows in the dataset rather than summing per row. epelton_0-1688132178892.png

 

Using a measure with the same DAX works, but the total is then wrong....

epelton_2-1688132921657.png

How do I get the correct sum per row and total

1 ACCEPTED SOLUTION
BIswajit_Das
Super User
Super User

Hello @epelton 
Check if any of the column data values are of decimal. That may be reason for the result to be in decimal.

OR

You can use
CC_booked_contract =
VAR _res = your DAX
RETURN

ROUNDUP(_res,0)
Hope if this solution helps you

View solution in original post

1 REPLY 1
BIswajit_Das
Super User
Super User

Hello @epelton 
Check if any of the column data values are of decimal. That may be reason for the result to be in decimal.

OR

You can use
CC_booked_contract =
VAR _res = your DAX
RETURN

ROUNDUP(_res,0)
Hope if this solution helps you

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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