Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
using the linked data table, I am trying to build a measure that sums all hours training completed, divides it by the number of active users and converts the final result in days (1 day=7.33 hours) , giving me the possibility to put additional filters: date, division, organisation, type of training, type of user.
The relevant information are stored in 2 separate tables, in the same data model, the 2 tables can be linked by the USER ID field.
Here an example of expected results:
TOTAL NR OF ACTIVE USER IN OPERATIONS: 137
TOTAL HOURS OF TRAINING COMPLETED 3172
AVERAGE NR OF TRAINING DAYS PER PERSON =3.1
Thank you!
Solved! Go to Solution.
@Anonymous ,
Create three measures using dax below:
TOTAL NR OF ACTIVE USER IN OPERATIONS = CALCULATE(COUNT(Users[ID (User)]), FILTER(Users, Users[Division] = "OPERATIONS" && Users[Active (User)] = TRUE())) TOTAL HOURS OF TRAINING COMPLETED = SUM('Completed Training'[Contact Hours (Item)]) AVERAGE NR OF TRAINING DAYS PER PERSON = [TOTAL HOURS OF TRAINING COMPLETED] / [TOTAL NR OF ACTIVE USER IN OPERATIONS] / 7.33
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Create three measures using dax below:
TOTAL NR OF ACTIVE USER IN OPERATIONS = CALCULATE(COUNT(Users[ID (User)]), FILTER(Users, Users[Division] = "OPERATIONS" && Users[Active (User)] = TRUE())) TOTAL HOURS OF TRAINING COMPLETED = SUM('Completed Training'[Contact Hours (Item)]) AVERAGE NR OF TRAINING DAYS PER PERSON = [TOTAL HOURS OF TRAINING COMPLETED] / [TOTAL NR OF ACTIVE USER IN OPERATIONS] / 7.33
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |