Summary Qualifications

[SharonCNE]

I need help trying to determine if people are qualified for a task.  Qualifications are a combination of different classes/courses that need to be taken, however some classwes/courses can be used in several different qualifications.

In the example I show 3 different qualifications (6 classes each) and also completion dates for 2 users for several classes.  How do I show that Jayne is qualified in Qualification 1 but not 3 etc?

Qualification	Class
1	Course A
1	Course B
1	Course C
1	Course G
1	Course H
1	Course I
2	Course A
2	Course B
2	Course C
2	Course D
2	Course E
2	Course F
3	Course A
3	Course B
3	Course C
3	Course J
3	Course K
3	Course L

Name	Class	Complete Date
Jayne	Course A	2/10/2021
Jayne	Course B	2/10/2021
Jayne	Course C	2/10/2021
Jayne	Course D
Jayne	Course E
Jayne	Course F
Jayne	Course G	3/15/2021
Jayne	Course H	3/15/2021
Jayne	Course I	3/15/2021
Jayne	Course J
Jayne	Course K
Jayne	Course L
Jayne	Course M
Jayne	Course N
John	Course A	2/10/2021
John	Course B	2/10/2021
John	Course C	2/10/2021
John	Course D
John	Course E
John	Course F
John	Course G
John	Course H
John	Course I
John	Course J	6/2/2021
John	Course K	6/2/2021
John	Course L	6/2/2021
John	Course M
John	Course N

[AlexisOlson · Accepted solution]

You can compare the set of classes for each qualification to the set of classes completed by each person.

IsQualified = 
VAR QualClasses = VALUES ( Quals[Class] )
VAR NameClasses = CALCULATETABLE( VALUES ( Courses[Class] ), NOT ISBLANK ( Courses[Complete Date] ) )
RETURN
    ISEMPTY ( EXCEPT ( QualClasses, NameClasses ) )