Forum Discussion
New measure for average
Hi all,
I've got a table that shows
Trainer name, trainee names, expected progress
I'm trying to create a new measure to show the average expected progress for all trainees with each trainer, but am struggling on the syntax. Any help would be appreciated.
Dave J
Anonymous
Based on your comment, I came up with the following:
Avg =CALCULATE(AVERAGE(DetailsSheet[ExpectedProgress]))I created some sample data I felt may match your scenario; I used two trainers & two trainees. Each trainee had three training events (two events from the same trainer).I'm attaching printscreens of the data in excel, the PBI file, & some screenshots.The training expected progress details
Pivot showing avg of trainer1
Pivot showing avg of trainer2Put these on my Google Drive; haven't used this in a while so let me know if links don't work.
4 Replies
- HotChilli
Community Champion
Help us out. Post some data and your desired outcome please.
An example of the data below. I'd like to create a measure to say eg
Trainer Expected Progress Actual Progress
A 57.1 62.8
B 65 59.8
where the numbers are the average of all trainees with the trainer (ie total of all actual progress/number of trainees).
Unique Number Trainee Title Actual Progress Expected Progress Trainer 8148685788 Alan LGV Driver Standard 99.3 91.2 Paul Rowden 6579783779 Barbara LGV Driver Standard 50 90.4 Richard Hicks-Williams 5252972663 Charles Supply Chain Warehouse Operative Standard 9.1 34.3 Paul Karalius 7384299356 David Supply Chain Warehouse Operative Standard 2 34.3 Paul Karalius 3918674052 Edward LGV Driver Standard 29.7 50.6 Stuart Hulme 3315247578 Frances LGV Driver Standard 29 59.4 Neil Ridgway 5389836617 Gail Supply Chain Operator Standard 100 100 Chris Moore 4237732303 Helen LGV Driver Standard 98.8 100 Chris Takle 3210139201 Ian Team Leader Supervisor Standard 79.7 100 Nichola Dempster 6924554228 John LGV Driver Standard 52.5 93.1 Phil Greenhalgh 5754240448 Keeley LGV Driver Standard 49.3 99.9 Ross Wann 8632404856 Mick Team Leader Supervisor Standard 64.8 65.6 Paula Woolmore 4385683912 Noel LGV Driver Standard 99.1 100 Darrel Thompson 9815019936 Olive Operations Departmental Manager Standard 2 57.6 Dave Laing 1347667678 Penelope Team Leader Supervisor Standard 16.2 32.7 Gail Cooper 7171066524 Queenie Team Leader Supervisor Standard 36.6 56.3 Paula Woolmore 3635306788 Richard LGV Driver Standard 21.7 71.7 Phil Greenhalgh 3053710241 Stephen Pearson BTEC Level 3 Diploma in Management (QCF) 100 100 Nichola Dempster 6834524281 Thomas Team Leader Supervisor Standard 81.9 100 Gail Cooper
Anonymous
Based on your comment, I came up with the following:
Avg =CALCULATE(AVERAGE(DetailsSheet[ExpectedProgress]))I created some sample data I felt may match your scenario; I used two trainers & two trainees. Each trainee had three training events (two events from the same trainer).I'm attaching printscreens of the data in excel, the PBI file, & some screenshots.The training expected progress details
Pivot showing avg of trainer1
Pivot showing avg of trainer2Put these on my Google Drive; haven't used this in a while so let me know if links don't work.
