Hi I'm trying to show the average hours per week per employee. The table contains Employee Name, hours, Project Name and week_number. One employee can have multiple projects in one week. I tried the following: Avg_hours = CALCULATE(AVERAGE(Tracker[Hours]), ALLEXCEPT(Tracker, Tracker[Employee_name)], Tracker[WeekNum])) But this is returning the same number regardless the week selected. Am I doing something wrong? Thanks, Ezequiel

Hi, Drag Employee Name and Start of week to the Table visual and write this measure =AVERAGE(Tracker[Hours]) Hope this helps.

Average hours per week | Microsoft Fabric Community

Super User

Can you share some more details on the information and data, share an example of the file and expected result?

I made a simple PBIX file and I'm getting changes on a card based on a slicer of the week but this can be different from your results.

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

Regards,

MFelix

Microsoft Employee

As example an employee has this data

Using the formula Avg_hours = CALCULATE(AVERAGE(Tracker[Hours]), ALLEXCEPT(Tracker, Tracker[EmployeeName], Tracker[WeekNum]))

The result I'm getting is 6.79 for the week of 7/29, 8/5, 8/12. The expected result would be

Week of 7/29: 7 hours

Week of 8/5: 11.67 hours

Week of 8/12: 5 hours

Thanks for the help

Ezequiel