Hi all,

I have two columns on my Data Model ,one that checks if it's a working date and another with the employees of each given date.
I tried to create a measure to calculate how many hours these employees will produce(8 Hrs work) which works fine on the pivot table for each date but the total is not showing the correct number(due to the fact that the employees number is not the same every day).

I'm guessing that my Dax is missing a filter or something since i multiply column row by column row..

Example below instead of getting 1120 which is the real sum i get another number)



Date Leaves Employees WorkDay Hours

01/10/2021 7 1 56
02/10/2021 7 0 0
03/10/2021 7 0 0
04/10/2021 7 1 56
05/10/2021 7 1 56
06/10/2021 7 1 56
07/10/2021 7 1 56
08/10/2021 7 1 56
09/10/2021 7 0 0
10/10/2021 7 0 0
11/10/2021 7 1 56
12/10/2021 7 1 56
13/10/2021 7 1 56
14/10/2021 7 1 56
15/10/2021 7 1 56
16/10/2021 7 0 0
17/10/2021 7 0 0
18/10/2021 7 1 56
19/10/2021 7 1 56
20/10/2021 7 1 56
21/10/2021 7 1 56
22/10/2021 7 1 56
23/10/2021 1 7 0 0
24/10/2021 6 0 0
25/10/2021 6 1 48
26/10/2021 6 1 48
27/10/2021 6 1 48
28/10/2021 2 6 1 48
29/10/2021 4 1 32
30/10/2021 4 0 0
31/10/2021 4 0 0
TOTAL 3 7 21 1176




Any suggestion would be more than welcome!

Cheers,
Kyr Manolis