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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
epelton
Frequent Visitor

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
Resolver III
Resolver III

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
Resolver III
Resolver III

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.