topic Re: Comparing two measures from same column in App Development

Comparing two measures from same column

alurubs — Mon, 08 Jul 2019 05:31:40 GMT

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

Re: Comparing two measures from same column

Lisa_P — Mon, 08 Jul 2019 05:51:21 GMT

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

Avg([Time booked])

Re: Comparing two measures from same column

avinashelite — Mon, 08 Jul 2019 06:21:35 GMT

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