topic Wrong totals in DAX Commands and Tips

Wrong totals

feralvarez994 — Wed, 20 Jul 2022 15:41:47 GMT

Hi everyone! I have a table with some measures that i have created. The thing is that the totals doesnt show the correct number that it should, i think its because it treats the negative numbers as positive and it sums every row without distinct of positive and negative numbers.

Im attaching the PowerBI File , the sheet that matters is the first one (Repuestos). The columns that show wrong totals are Importe Neto, IVA, Facturado and Costo Total. How can i do to get the right totals having in consideration the positive and negative numbers as they truely are?

Thanks everyone!

PowerBI File

Re: Wrong totals

tamerj1 — Wed, 20 Jul 2022 16:00:44 GMT

Hi feralvarez994
Please check it this is ok https://www.dropbox.com/t/rfLf1WPbPejF9H7b

Re: Wrong totals

feralvarez994 — Wed, 20 Jul 2022 16:14:16 GMT

tamerj1 thanks a lot! it works fine, can you tell me why should i write first sumx and summarize? or why does the table didnt sum correctly?

Re: Wrong totals

tamerj1 — Wed, 20 Jul 2022 16:26:02 GMT

feralvarez994
You need to simulate the current filter context inside then sum the visible values as you see it in the matrix.