Forum Discussion
Real Totals
Hello everyone! I am having some trouble calculating the sum total of a calculated measure in a table. I need to do this action: (the absolute difference between baseline and historic column)...
mahoneypat
Microsoft Employee
Microsoft EmployeePlease try using SUMX to get the correct total. It references your existing measure but should give you the correct result both in your rows and your total.
NewMeasure = SUMX(VALUES(Table[Origin Site]), [Abs Difference])
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat