Help count the number of students that match all the selected requirements

[Anonymous]

Hi everyone,

I'm pretty new to PowerBI and I'm struggling to get my head around some of the more complex nested formulas.

I have this scenario that I'm trying to deal with:

First I have a hierachy slicer that uses a PATH table like so, 

Level 1	Level 2	Level 3
Subject 1
Subject 1	Module 1
Subject 1	Module 2
Subject 1	Module 1	Lesson 1

I then have an unpivoted table with the student IDs, an attribute column that contains the subject, module and lesson names, then a value column that says whether they have passed or not.

What I'm trying to achieve is, I want the ability to select random modules, lessons, etc., and display the number of students that have passed all of the selected requirements. 

Any help would be greatly appreciated,

Thank you
 

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, seems it's not very clear about your data model. 

I create a sample:

Table1.

Table2.

So, when you select a value in the three slicers: Level1, Level2 and Level3, do you want to get the number of students whose three levels are all "pass" ? 

Please check if my sample the same structure with yours, if not, please provide a example to clarify the problem.

Best Regards,
Community Support Team _ kalyj

[Anonymous]

Hi @v-yanjiang-msft ,

That's exactly what I am after thank you.

Adam