Total sales per employee & average sales of all employee - in ONE chart.
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.