Calculate weekly average of hours worked per user (updated with working measure,need help improving)

[Anonymous]

Edit!!

I kinda got it working now. I added a calculated column to sum up each person's daily hours, into a week total. 

Calculated Column- sum each person hours by week:

Week Total AVG p/TL = CALCULATE(SUM(Merged_August_forward[Total Phone Time Hours]), ALLEXCEPT(Merged_August_forward, Merged_August_forward[TeamLeads_Hierarchy_Table_Table.AGENT_NAME] ,Merged_August_forward[Date]))

Then i added a measure to average those weekly totals

Measure:

Week Total Overall AVG =



AVERAGEX(

    GROUPBY(Merged_August_forward, Merged_August_forward[Week of Year], Merged_August_forward[TeamLeads_Hierarchy_Table_Table.AGENT_NAME]),

    CALCULATE(SUM('Merged_August_forward'[Week Total AVG p/TL]))

)

Its probably not the most elegant way to do this. but it's at least giving me the desired output. I need this to exclude zeros but i have not been able to make <>0, FILTER to work. I'm using a page level filter to greater than zero for now. any ideas on making this more efficient/cleaner and exclude zeros?

[HotChilli]

Please post some data (not a picture) and your desired outcome. Somebody will help you.

[Anonymous]

Manager	Agent	Work Hours	Date	Start of Week
Jayson Costa	Esteban Riddle	3	8/12/2019 0:00	8/11/2019 0:00
Jayson Costa	Keely Liu	5	8/5/2019 0:00	8/4/2019 0:00
Jayson Costa	Alejandro Mckenzie	1	8/6/2019 0:00	8/4/2019 0:00
Jayson Costa	Addisyn Richards	4	8/7/2019 0:00	8/4/2019 0:00
Jayson Costa	Paulina Horn	8	8/8/2019 0:00	8/4/2019 0:00
Jayson Costa	Esteban Riddle	7	8/9/2019 0:00	8/4/2019 0:00
Jayson Costa	Keely Liu	1	8/12/2019 0:00	8/11/2019 0:00
Jayson Costa	Alejandro Mckenzie	4	8/5/2019 0:00	8/4/2019 0:00
Jayson Costa	Addisyn Richards	1	8/6/2019 0:00	8/4/2019 0:00
Jayson Costa	Paulina Horn	5	8/9/2019 0:00	8/4/2019 0:00
Titus Lee	Malakai Spencer	1	8/12/2019 0:00	8/11/2019 0:00
Titus Lee	Britney Noble	7	8/14/2019 0:00	8/11/2019 0:00
Titus Lee	Ellie Avery	8	8/5/2019 0:00	8/4/2019 0:00
Titus Lee	Helena Chen	8	8/6/2019 0:00	8/4/2019 0:00
Titus Lee	Jagger Giles	4	8/7/2019 0:00	8/4/2019 0:00
Titus Lee	Malakai Spencer	2	8/8/2019 0:00	8/4/2019 0:00
Titus Lee	Britney Noble	6	8/9/2019 0:00	8/4/2019 0:00
Titus Lee	Ellie Avery	5	8/12/2019 0:00	8/11/2019 0:00
Titus Lee	Helena Chen	7	8/13/2019 0:00	8/11/2019 0:00
Titus Lee	Jagger Giles	6	8/14/2019 0:00	8/11/2019 0:00
Chris Deleon	Kaleigh Riddle	3	8/15/2019 0:00	8/11/2019 0:00
Chris Deleon	Rayne Suarez	5	8/5/2019 0:00	8/4/2019 0:00
Chris Deleon	Antoine Guerra	8	8/6/2019 0:00	8/4/2019 0:00
Chris Deleon	Aaron Rivas	3	8/7/2019 0:00	8/4/2019 0:00
Chris Deleon	Brady Carney	2	8/8/2019 0:00	8/4/2019 0:00
Chris Deleon	Jayleen Reyes	7	8/9/2019 0:00	8/4/2019 0:00
Chris Deleon	Kaleigh Riddle	5	8/13/2019 0:00	8/11/2019 0:00
Chris Deleon	Rayne Suarez	5	8/14/2019 0:00	8/11/2019 0:00
Chris Deleon	Antoine Guerra	4	8/15/2019 0:00	8/11/2019 0:00
Chris Deleon	Aaron Rivas	5	8/5/2019 0:00	8/4/2019 0:00
Chris Deleon	Brady Carney	5	8/8/2019 0:00	8/4/2019 0:00
Chris Deleon	Jayleen Reyes	1	8/12/2019 0:00	8/11/2019 0:00

Week of 8/4
Chris	AVG 7 hours per agent wkly	7
Jayson	AVG 7 hours per agent wkly	7
Titus	AVG 5.6 hours per agent wkly	5.6
Week of 8/11
Chris	4.5 hours per agent wkly	4.5
Jayson	2 hours per agent wkly	2
Titus	5.2 hours per agent wkly	5.2
I need to display
the rolling average per manager (last 3)	Chris AVG (7,4.5)	5.75	since example only has 2 weeks
the overal current AVG per manager	Chris AVG (7,4.5)	5.75	since example only has 2 weeks
the overal current AVG (from agent level)	(8/4 - 6.53 AVG; 8/11 - 4.36 AVG	5.445	example only has 2 weeks, I have 2 years worth
the rolling overal average(last 3)(from agent level)		5.445
there is a 3rd category of leader above manager, would need the same averages for them too

Hope this table helps.  i can share an excel of the same if needed.