What about using a of the Total of the distinct count of students and comparing that to the Window_SUM of courses for a given student? I've attached a workbook that demonstrates this.
Students.twbx.zip 25.6 KB
I'm happy to provide explanation of anything if you'd like.
Usually, I'd try to give a little more, but am pressed for time just now. Please let me know if there is anything that doesn't make sense. Thanks!
Thanks for your efforts and quick response. I replied to your email from my outlook but am not sure if you even received it. My logic was similar to yours with minor changes i.e. equating the Course Count for a Student to the Total Number of Course we select (from the Course filter). I did tweak my approach and it seems to work fine now. Basically i created a calculated field called "Condition Check" with the following formula
If Countd ( [Course] ) = Total ( Countd ( [Course] ) ) Then 1 Else 0 End
Finally filter the results to only show values that are at least 1. I have enclosed a packaged Tableau Workbook with modified data (names instead of alphabets).