Total sales per employee & average sales of all employee - in ONE chart.

[Niels_NL]

Hey guys,

situation is the following:

• Sales table including 'revenue', 'date' and 'employee', etc.
• Employee table including 'employee', etc.

My challenge is to create a barchart per employee showing their individual total sales revenue.

And in the same barchart, I also want to see a bar with the average of all total sales revenues per employee.

So, if emp1 has a total of $30,000 and emp2 has a total of $40,000.

The average of all total sales revenues per employee would be $35,000.

And those 4 values, I'd like to have in my chart.

I've tried some things myself and I managed to get some DAX measures, but when I have 2 DAX measures for both values in 1 chart, the average of all total sales revenues per employee gets re-calculated for each individual employee again.

Any solutions?

Thanks!

~ Niels.

[Anonymous · Accepted solution]

Use Clustered column chart.

Put Emp on Axis and Revenue in Values

Then click on the Analytics button and add "Average Line"