Forum Discussion
epelton
Helper I
Helper ISum 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.
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
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
RETURNROUNDUP(_res,0)
Hope if this solution helps you
1 Reply
- BIswajit_Das
Impactful Individual
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
RETURNROUNDUP(_res,0)
Hope if this solution helps you