Forum Discussion

NithinBN's avatar
NithinBN
Helper II
3 years ago
Solved

Count value between 2 tables

Hello,

I have a student and dept table like this having cordinality (1 to *), meaning a student can be part of multiple department. 

How can I find out which all students are linked to a department(count students having link\registered  to department )

 

Thanks you!

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    NithinBN , Use these measures to find students not linked. Plot M2 with Student name

     

    M1= Countrows([Department])

     

    M2= Countx(Values(Student[ID]), if( Isblank([M1]), [ID], blank()) )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    NithinBN , Use these measures to find students not linked. Plot M2 with Student name

     

    M1= Countrows([Department])

     

    M2= Countx(Values(Student[ID]), if( Isblank([M1]), [ID], blank()) )