Using aggregate with Sum measure and for each employee doesn't work

[alespooletto]

I am trying to get an average sum of hours worked for each employee across all dates in a dashboard. This is only for 2024, but when I show it it gives me an average of 307. 

THe formula I am using 

```

AvG(Aggr({< Weekday = {'Lu', 'Ma', 'Me', 'Gi','Ve'}, Employee=>} Sum(Duration), Date))

```

Can anybody help me work this out?

[Antoine04 · Accepted solution]

Hello what about that ?

- AvG(Aggr({< Weekday = {'Lu', 'Ma', 'Me', 'Gi','Ve'}, Employee=>} Sum(Duration), Date, Employee))

Regards