many to many relationship problem

[NILU090]

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.

[Anonymous]

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnt75]

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.

[darkinvader_]

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 Video 

Regards

darkinvader