How do I calculate the distinct count of subjects meeting the above parameters AND have a scoring of > 3.2? That way I can use this to divide by the above expression to get my desired KPI value.
Sample data set:
Acad Year
Institution
Subjects
Location
Scoring
2019
A
Math
Campus
3
2019
A
Biology
HBL
3.2
2019
A
Chemistry
Campus
3.4
2019
A
Physics
Campus
3.5
2019
B
Math
HBL
3.1
2019
B
Biology
Campus
3.2
2019
B
Chemistry
Campus
3.5
2019
B
Physics
HBL
3.7
2019
C
Math
HBL
3.3
2019
C
Biology
Campus
3.6
2019
C
Chemistry
HBL
3.8
2019
C
Physics
Campus
2.8
Taking into consideration only those taught on Campus: