Загрузка данных

Completed Required Courses Count =
VAR CurrentEmail =
    SELECTEDVALUE(Personal[Email])

VAR CurrentProfile =
    SELECTEDVALUE(Personal[Profile])

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