Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
98 | |
39 | |
30 |