Forum Discussion
Mr_Robot0092
Helper I
Helper INeed Assistance with DAX Measure: Filtering Students by Selected Classes
Hello, I have 2 tables Student and Class , a student can have multiple Class then i create a table called Enrollement to manage the many to many. As bellow a simple of the data : Student: ID ...
Ashish_Mathur
Super User
Super UserHi,
Shouldn't the answer be 3? John, Merida and Patrick. Each one of them has take either only German or only Math or only Both German and Math
Mr_Robot0092Helper I
Helper IHi Ashish_Mathur ,
Sure John, Merida and Patrick are the good answer.
But in my case i have a table with a Class dimension and count Student the result will be like as bellow :
| Class | CountStudent |
| Math | 2 |
| German | 2 |
- Ashish_Mathur
I am completely confused. On one hand you so that the answer should be 3 but in the table you show 2.
- Mr_Robot0092
in my case i select Class with the Count Student