Dashboard Filter with Many to Many relationship (DAX)

[pickslides]

Hi 

I have a dashboard and I want to set up a filter on "Title" which are different after school activities. This Dashboard will summarise how well students perform academically (TABLE results) and should return values to be compared with students not doing any activities. 

My two tables have a many to many relationship on UID. 

If the filter shows "Junior Rock Band" then average these values against others. Can DAX work backwards from the Dashboard filter and populate the Results table with the "Title" choosen?

Q

[kitgo2]

Can you clarify this statement "average these values against others"?  are you looking for different values in the result column or just the title Junior Rock Band?

[pickslides]

Just the title, then I will be able to analyse the data on this parameter. But this parameter should be dynamic in DAX against the filter if possible. 

Any other many to many tips are helpful

Q

[kitgo2]

when you join your tables via the UID make sure you have Both in the cross filter direction and check the apply security filter in both directions that way when you filter off the title it will filter both tables. You would use the field title as your slicer if I am understanding you correctly.