---

Fully Trained Employees =
VAR EmployeesStatus =
    ADDCOLUMNS(
        Personal,
        "RequiredCoursesCount",
            COUNTROWS(
                FILTER(
                    ReqCourse,
                    ReqCourse[Profile] = Personal[Profile]
                )
            ),
        "CompletedCoursesCount",
            COUNTROWS(
                FILTER(
                    ReqCourse,
                    ReqCourse[Profile] = Personal[Profile]
                        &&
                    COUNTROWS(
                        FILTER(
                            Training,
                            Training[Email] = Personal[Email]
                                &&
                            Training[Course] = ReqCourse[Course]
                                &&
                            Training[Status] = "Trained"
                        )
                    ) > 0
                )
            )
    )
RETURN
    COUNTROWS(
        FILTER(
            EmployeesStatus,
            [RequiredCoursesCount] = [CompletedCoursesCount]
        )
    )