Grand Total of Measures did not match with SUM of row values

[arcejames]

Hello,

I've created a measure that multiplies TotEndingInventory (wish is a meassure) by TotStCost ( which is a measure as well)  But, when I put that measure in a table, the grand total is performing its original function (that is TotEndingInventory * TotStandarCost instead of summarizing the individuals row values.
According with the screenshot below, the total of TotEndingInventoryVal column is $211 437, which is the result of TotEndingIventory * TotStCost, instead of $72 945, which is the SUM of the row values in this column...
Can anybody help me please?
Tks in advance.

[Ashish_Mathur · Accepted solution]

Hi,

Try this

=IF(HASONEVALUE([SAPMaterial]),[TotEndingInvValue],SUMX(SUMMARIZE(VALUES([SAPMaterial]),[SAPMaterial],"Total",[TotEndingInvValue]),[Total]))

Hope this helps.

[arcejames]

It it working. Thank you so much

[jdbuchanan71]

Hello @arcejames 

Are the amounts that are feeding into your two measures [TotEndingInventory] and [TotStCost] in the same table as the SAPMaterial field? 
I will assume this is the case and the table is called Sales.

You will want to use an iterator over your table to do the calc, something like

TotEndingInvVal2 = SUMX ( Sales, Sales[EndingInventory] * Sales[StCost])

Please note that the EndingInventory and StCost in my measure are the columns in the sales table, the ones you sum in your existing measure.

If I have missed the mark, please share a sample of your model so we can help further.

[MitchM]

Can you please share your measures and/or a mock dataset?