I am trying to create a measure to compare averages for a time period of all users against a given users numbers for that time period. I am using the measure below.
Hi there, I think there are 2 issues here:
a) Formula to be clearer defined - Total average cannot equal the sum of individual averages, so using DivisionCount function will probably not work.
b) Create a clear Employee ID table which has unique values (can take a payroll query, refference it, Drill Down and extract only the Employee ID, department and name). This will help you long-term anyway.
c) What do you try to show?
I would reccomend to get clear on what you try to achieve:
do you want to see the total company average vs. individual average? Then use AVERAGE as a measure or even as a calculated column - but then the with a different visualization than a stacked graph?
Think of a different Matrix table too.
I hope this helps.
I'm not very clear about your requirement. I don't find the 392 and 40 in the screenshot. Please clarify it.
It would be better if you could share the pbix file.
Thanks for following up, Qiuyun! I cannot share my pbix file because its source is our CRM system and there is information we would not like to share publicly. Incase I was unclear, I have written the following equation to calculate the average number of records created per user and then have used the activity date field that all these records have to determine the average amount of records created by the users contributing to these records by qtr/ year. Everything sums up perfectly at a high level.