Forum Discussion
Incorrect subtotals
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.
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])
2 Replies
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])Thank you.
