Forum Discussion
Solved
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 tota...
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])
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.