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)
)
Hi rbriga
I have tried this. . It seems like it's not working; it's showing a blank result. Any other suggestions . .
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)
)