Forum Discussion

NILU090's avatar
NILU090
Icon for Helper II rankHelper II
3 years ago

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 act...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

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.