Grand total of column is zero

[lwkwan]

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%)])

[TaylorPBI21]

Hi @lwkwan ,

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

[tamerj1 · Accepted solution]

Hi @lwkwan 
Please try

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

[lwkwan]

Thank you so much! It works! 🙂

[Anonymous]

@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 @lwkwan 

Thank you. 

[tamerj1]

@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]

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