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)

    )

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Here's another approach:

 

COUNTROWS (
    FILTER (
        VALUES ( Table2[EMPLOYEE ID] ),
        CALCULATE ( SELECTEDVALUE ( Table2[LEARNING STATUS] ) ) = "Complete"
    )
)

This works because if there are multiple values, then SELECTEDVALUE returns a blank.