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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I am trying to sum 3 columns. This DAX for a calculated column sums all rows in the dataset rather than summing per row.
Using a measure with the same DAX works, but the total is then wrong....
How do I get the correct sum per row and total
Solved! Go to Solution.
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
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