Line chart - compare individual vs average

[Anonymous]

Hello, Im making a line chart where you can select an invidual employee and compare his/hers working hours to the average of all employees.

Here is what i got now. You can select the employee in the slicer to the left. The working hours for the employee is shown in the line chart in the middle. The line chart to the right is based on a measure which calculates the average by dividing total hours with total number of employees. However I want to combine the line charts into a single one. But since it interacts with the employee slicer it wont show the average for all employees. 

Here is what I want:

[Gordonlilj]

Hi,

You could try using the the ALL function inside your measure. Perhaps something like the example below

CALCULATE( AVERAGE( 'Table'[Hours] ), ALL( 'Table'[Employee] ) )