Comparing two measures from same column

[alurubs]

I am trying to create a very simple bar graph with the below data.

Employee	Time booked
A	3
A	2
A	5
B	8
B	2
C	4
C	6
C	7
C	9
D	1
D	4
D	8
D	2
E	6

In the bar graph what I need is a comparison of the average time booked by employee A versus the average time booked by all five employees. The graph should show the first bar for employee A with 3.33 value and the second bar for all five employees with value 4.78

What do I need in dimensions and how can I get two Measures from the same Time booked column, first measure being average for employee A only and second measure being  the average for all employees?

Thanks

Bala

[Lisa_P · Accepted solution]

Just create a bar chart with 2 measures:

Measure 1:

Avg({<Employee={A}>}[Time booked])

Measure 2:

Depends on if you want all bookings averaged, or averaged by employee.

avg(aggr(Avg([Time booked]), Employee))

or 

Avg([Time booked])

[avinashelite]

you need just the A to be compared with all the average or you want to memic this with other values also ?