Incorrect SUM

[PSRai]

I have the ActualLabourMinutes that need to be converted into Hours.. I have created a column that is called Labour Hours however its applying the total hours across all rows instead of sum of individual rows. The output column should be ActualLabourHours which I need help to create?

I used the follow - LabourHours = CALCULATE(SUMX(WorksOrderTracking,WorksOrderTracking[ActLabourMinutes])/60

ActualLabour

Minutes               LabourHours     ActualLabourHours

2942                       337.4333333       49.03333333

982                         337.4333333       16.36666667

4038                       337.4333333       67.3

2707                       337.4333333       45.11666667

1641                       337.4333333       27.35

872                         337.4333333       14.53333333

3305                       337.4333333       55.08333333

296                         337.4333333       4.933333333

3463                       337.4333333       57.71666667

20246                    3036.9                   337.4333333

[rajulshah · Accepted solution]

Hello @PSRai,

Please try the following DAX query in your calculated column query:

LabourHours = WorksOrderTracking[ActLabourMinutes]/60

Let me know if this works. 

[amitchandak · Accepted solution]

Create a new column ,

LabourHours =WorksOrderTracking[ActLabourMinutes]/60

[rajulshah · Accepted solution]

Hello @PSRai,

Please try the following DAX query in your calculated column query:

LabourHours = WorksOrderTracking[ActLabourMinutes]/60

Let me know if this works.