Forum Discussion
Solved
Count based on condition - Completion Status
Hi, I need to create a measure to count employees that completed modules ( module completed if all learnings associated are completed) EMPLOYEE ID LEARNING LEARNING STATUS MODULE 342...
Silly mistake on my side.
1. Build a support measure:
Courses =
COUNTROWS('Table')
2. This will return the number of employees who completed all their modules:
SUMX(
VALUES('Table'[EMPLOYEE ID]),
IF([Courses] = CALCULATE([Courses],KEEPFILTERS('Table'[LEARNING STATUS] = "Complete")),1,0)
)
Sorry , It should be 3. it was a typo. . it's a count of employees who completed the modules. I have updated the post. your help is highly appreciated 🙂