Forum Discussion

Mr_Robot0092's avatar
Mr_Robot0092
Icon for Helper I rankHelper I
3 years ago

Need 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 ...
Need Help
Mr_Robot0092's avatar
Mr_Robot0092
Icon for Helper I rankHelper I
3 years ago

Hello Ashish_Mathur 

Thanks for replying.

Your solution doesn't answer to my question.

The idea is display a table with Class and Cout of student Like as bellow : 

i filtered on class Math & German : 

ClassCountStudent
MAth2
German2

 

Thanks for your help !

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

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_Robot0092's avatar
    Mr_Robot0092
    Icon for Helper I rankHelper I
    3 years ago

    Hi 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 : 

    ClassCountStudent
    Math2
    German2

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      I am completely confused.  On one hand you so that the answer should be 3 but in the table you show 2.