Forum Discussion
khisla
Helper II
Helper IICalculate Total - Wrong Total Sum
Hello All- I need to calculate the total hours worked by employees on a particular date AND specific store. See data below and expected total hours column calculated. Date Store Employe...
Hi,
Please check the below picture and the attached pbix file.
It is for creating a calculated column.
CC Total Hours = VAR _date = Data[Date] VAR _store = Data[Store] VAR _t = FILTER ( Data, Data[Date] = _date && Data[Store] = _store ) RETURN SUMX ( _t, Data[Hours Worked] )
Jihwan_Kim
Super User
Super UserHi,
Please check the below picture and the attached pbix file.
It is for creating a calculated column.
CC Total Hours =
VAR _date = Data[Date]
VAR _store = Data[Store]
VAR _t =
FILTER ( Data, Data[Date] = _date && Data[Store] = _store )
RETURN
SUMX ( _t, Data[Hours Worked] )
khislaGot the same result as my DAX which is incorrect. The expected total hours vary
Date Store Employee # Hour Worked Total Hours 01/04/2025 IL207 208468355 7.72 81.99 01/04/2025 IL207 211453196 7.9 81.99 01/04/2025 IL207 214144669 7.57 81.99 01/04/2025 IL207 216350876 4.93 81.99 01/04/2025 IL207 216350884 7.68 81.99 01/04/2025 IL207 331725085 6.45 81.99 01/04/2025 IL213 208841502 7.6 13.32 01/04/2025 IL213 327877239 5.72 13.32 02/04/2025 IL214 206538415 6.22 76.01 02/04/2025 IL214 209457290 8.2 76.01 02/04/2025 IL214 212804512 8 76.01 02/04/2025 IL214 213031131 6.3 76.01 02/04/2025 IL214 213764079 6.2 76.01 02/04/2025 IL214 314378134 8.27 76.01 02/04/2025 IL214 319061750 6.07 76.01 02/04/2025 IL214 327825824 6.25 76.01 02/04/2025 IL214 328406574 6.4 76.01 02/04/2025 IL214 345707210 6.02 76.01