Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!