Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
@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()) )
@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()) )
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |