topic Re: Real Totals in DAX Commands and Tips

Real Totals

Anonymous — Sun, 26 Jul 2020 23:39:35 GMT

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)

And then, sum out the total calculated column:

The result has to be 44,308.55

But in power BI, it calculates the absolute difference between the total sums of the columns.

Hope someone can help me!!!

Re: Real Totals

mahoneypat — Mon, 27 Jul 2020 01:27:28 GMT

Please 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

Re: Real Totals

amitchandak — Mon, 27 Jul 2020 01:51:23 GMT

Anonymous , Try like

New Abs Difference= SUMX(summarize(Table,Table[Origin Site],,Table[destination Site],"_1", [Abs Difference]).[_1])