The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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