Creating an efficient semantic modeling

Hi, sivarajan21 

I looked at your example file and you should use the ID column of the bridge table to connect to the corresponding ID column of the other table. Your relationship should be one-to-many or many-to-one, avoiding one-to-one and many-to-many. Here's a view of possible relationships:

You should understand what a relationship means and what it does:

It is recommended that you read the following articles to understand the background of the relationship and then build an appropriate relationship according to your actual needs. In your bridging table, the ID field may be a good connection key.

Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified - RADACAD

What is the Direction of Relationship in Power BI? - RADACAD

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI - RADACAD

In addition, you may also need a date sheet. You can use DAX expressions to create a date calculation table so that you can filter the data by date later.

Benefits of using a calendar table in Power BI - Data Bear - Power BI Training and Consulting

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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