Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Many to Many Relationship

Hello, please help in such situation:


I have 3 tables without unique prospect account(simple example). I need a relationship with Event-Contracts and Event-Sales. The main idea to choose event and to show data analysis about contracts and sales. One prospect may be in different event-bases.


How to make this connection? maybe CalculateTable, but how to easy filter every Event?


Community Support
Community Support

Hi Eugene-CHN,


Two one-many relationships  and a median table compose a many-mant relationship. You'd better create a new table which contain [Prospect] column between the three tables and make relationship between the three table and the new median table.


Keep in mind, the values in the column of new median table should be unique.


Hope it's helpful to you.


Jimmy Tao

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.