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.