Learner Alert! Relationships and Measures

Hi VijayP 
Thanks for taking the time to look at this. Unfortunately this is not quite what I need.  If you refer to my original file,  you will see the pie chart I have created for Attendance Band report YTD with the %Attendance measures. 

If I select a single ID from student list, then this pie chart filters correctly. 

If I try the reverse, ie selet 0-95% select of the pie chart, then I wanted it to filter the Student List to just show the IDs for those where the measure data reflects that. As you can see this does not work:

As the Attendance Band Report YTD, the measures (and all other visuals) are being filtered by the slicer for the Term (from Date table), I think the fact that there is no relationship between the students and the Date table that is causing the issue. 

So I either need to find some way of setting up the relationship or by changing the way I am doing the calculations to count how many students fall into each attendance band group.

Hope that makes sense!