Forum Discussion

pickslides's avatar
pickslides
Icon for Helper I rankHelper I
4 years ago

Dashboard Filter with Many to Many relationship (DAX)

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) a...
pickslides's avatar
pickslides
Icon for Helper I rankHelper I
4 years ago

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's avatar
kitgo2
Icon for Advocate I rankAdvocate I
4 years ago

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.