topic Re: Grand total of column is zero in DAX Commands and Tips

Grand total of column is zero

Anonymous — Fri, 17 Feb 2023 08:55:27 GMT

When using PowerBI, when i multiply (GP/Unit Est) by (Units Sold Dev[Act vs Act Est%]), the grand total of this formula is zero.

Could you advise me how can i get the correct grand total?

I tried using SUMX, but it doesnt seem to work.

sumx(Table,Table[GP/Unit Est]*Final[Units Sold Dev (Act vs Act Est%)])

tamerj1 — Fri, 17 Feb 2023 14:00:54 GMT

Hi Anonymous
Please try

= SUMX ( VALUES ( 'Table'[Product Group Description] ), [GP/Unit Est] * [Units Sold Dev (Act vs Act Est%)] )

Anonymous — Fri, 17 Feb 2023 13:34:33 GMT

tamerj1
Sir, the measure you provided is not working.

And I don't know why the G*F column for me shows different values than in the requirement Image by Anonymous

Thank you.

tamerj1 — Fri, 17 Feb 2023 14:02:10 GMT

Anonymous
This is supposed to be a measure not a calculated column.

Also I assume [GP/Unit Est] and [Units Sold Dev (Act vs Act Est%)] are measures?

Anonymous — Sat, 18 Feb 2023 10:17:09 GMT

I don't know tamerj1
Can you please reply regarding the same questions? Anonymous

TaylorPBI21 — Sat, 18 Feb 2023 11:07:47 GMT

Hi Anonymous ,

Could you copy and paste your table into a reply so I can work with it?😎

Anonymous — Mon, 20 Feb 2023 02:33:51 GMT

Thank you so much! It works! 🙂