Average of a counta measurement

[Arkhos94]

I'm working on a power bi report for a training center

I have 2 database coming from excel :
- one with a trainee list (important column : user name, training session ID)
- one with a training session list (important column : training session ID, training classification)

training classification can be either "tech training", "com. training" or "other" depending on the session

Both base are connected using the training session ID

I first want to know how many trainee I have per session. That's easy, I create a new measurement in " training session list" : NbTrainee = COUNTA('Trainee list'[User Name])

This works

So know to know the average number of trainee per session in each of the 3 possible classification

I tried playing with average but I can't find a way to make it work. Can someone help me ?

[amitchandak · Accepted solution]

@Arkhos94 , Try a measure like

averageX(values('Trainee list'[training session ID]),calculate(COUNTA('Trainee list'[User Name])))

[Arkhos94]

It seems to work, thanks