Forum Discussion

tortusstorylist's avatar
tortusstorylist
Frequent Visitor
3 years ago
Solved

Help keeping aggregate measures in a visual. Trying to compare individuals to average by category.

Hello,

 

I am trying to create a visual that has individual metrics, as well as the average of those same metrics by employee type. 

 

 

As expected, the average measure is showing the average for that individual. What I want to do is to have the static average by "StaffType" in the "BudgetHoursAverage" column, as shown below:

 

So, I would like to have 31.50 for all individuals who's StaffType is "DIR", etc...

 

I had created a measure I thought would accomplish this but it is still returning the average by individual:

 

BudgetHoursAverage =
VAR __table1 = SUMMARIZE('tablename', 'tablename'[StaffType], "name1", SUM('tablename1'[ProdHoursMonth]) / [FTE Total])
RETURN
CALCULATE(AVERAGEX(__table1, [name1]), FILTER('tablename', 'tablename'[StaffType]))
 
Note, that this is calculating based off of two tables (tablename and tablename1). I can provide more information as needed, as well.
 
Any help would be greatly appreciated!
 

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    This measure works

    Measure = CALCULATE([HoursAverage],ALL(Sheet1[Staff Name]))

    Hope this helps.

7 Replies