New measure for average

[Anonymous]

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 · Accepted solution]

@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 detailsPivot showing avg of trainer1Pivot showing avg of trainer2

PBI file

Excel file

Put these on my Google Drive; haven't used this in a while so let me know if links don't work.

[Anonymous]

excellent, thanks. I had an error in my syntax, so got nonsensical outcomes. Yours worked perfectly.

cheers

Dave J

[HotChilli]

Help us out.  Post some data and your desired outcome please.

[Anonymous]

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