Incorrect subtotals

[Ashish_Mathur]

Hi,

I have an input and an output worksheet in this workbook with very simple SUM() and multiplication DAX measures.  In the output worksheet, the numbers in column P at the subtotal and grand total cells are wrong.  In the Remarks column (column Q), i have shown what the correct result should be (refer range Q57:Q72).

Could you kinldy help me in resolving this issue.

Thank you for your help.

[jdbuchanan71 · Accepted solution]

Hello @Ashish_Mathur 

The Measure for PC is calculating the sum of the columns involved then multipluying the reulsts.

=[Mechancial efficiency]*[Pc_per_hour]*[Production days]*[Production hours]

If you change the DAX expression to be a SUMX you will get the correct result.

=SUMX(Data,[Mechancial efficiency]*[Pc_per_hour]*[Production days]*[Production hours])

[Ashish_Mathur]

Thank you.