Forum Discussion

Juma1231's avatar
Juma1231
Frequent Visitor
4 years ago
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...
  • rbriga's avatar
    rbriga
    4 years ago

    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)

    )

rbriga's avatar
rbriga
Icon for Impactful Individual rankImpactful Individual
4 years ago

Just to clarify- why is the expected result = 2?

If it's a count of emplyees who finished their courses, there are 3 (1111,2112,2122);

If it's a count of learnings that all employees (assigned) finished, there's 1 (Microsoft Excel).

 

What are the 2 you expect to count, in this example?