Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Line chart - compare individual vs average

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:

Need Help
Tips and Tricks

1 Reply

  • Gordonlilj's avatar
    Gordonlilj
    Solution Sage
    6 years ago

    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] ) )