Forum Discussion
many to many relationship problem
Hi Team,
Needed solution from long back, stuck on this point.
I have 2 tables. both has multiple ID. Table (right side) contains ID mulitple time as more than 2 person can be a part of 1 single activity ( or id). I want to filter table & measures when name is selected from table only belongs ID should filter.
I tried with brigde table. however its not working. please help me on this.
3 Replies
Hi NILU090 ,
I would suggest an easy asnwer which is to create another dim table which contains distinct ID', but it would cost you a peforance setback.Or else you can reffer this video whcih might solve your problem.
YouTube VideoRegards
darkinvader
You could create a many-to-many relationship but make the filter direction single so that Table filters Fact.
Depending on the size of Table and the number of distinct names, you could also consider creating a Name table using DISTINCT('Table'[Name]) and create a one-to-many relationship from that to Table. You would then use the new Names table in your slicers and visuals.
Hi NILU090 ,
Here I create a sample file to have a test.
It works onmyside.
Please compare my sample with yours.
For reference: Many-to-many relationship guidance - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
