Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
85 | |
82 | |
69 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |