Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 ?
Solved! Go to Solution.
@Arkhos94 , Try a measure like
averageX(values('Trainee list'[training session ID]),calculate(COUNTA('Trainee list'[User Name])))
@Arkhos94 , Try a measure like
averageX(values('Trainee list'[training session ID]),calculate(COUNTA('Trainee list'[User Name])))
It seems to work, thanks
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |