---

Completed Required Courses Total =
SUMX(
    Personal,
    VAR CurrentEmail = Personal[Email]
    VAR CurrentProfile = Personal[Profile]

    VAR CompletedCourses =
        FILTER(
            DISTINCT(
                SELECTCOLUMNS(
                    FILTER(
                        ReqCourse,
                        ReqCourse[Profile] = CurrentProfile
                    ),
                    "Course",
                    ReqCourse[Course]
                )
            ),
            VAR CurrentCourse = [Course]
            RETURN
                COUNTROWS(
                    FILTER(
                        Training,
                        Training[Email] = CurrentEmail
                            &&
                        Training[Course] = CurrentCourse
                            &&
                        Training[Status] = "Trained"
                    )
                ) > 0
        )

    RETURN
        COUNTROWS(CompletedCourses)
)