Many to Many relationship between 3 tablesi w

[kala2]

i want to set up many to many relationship between three tables:

Table 1

Table 2:

Table 3:

Is it possible to set up many to many relationship between three tables?

[Mohammad_Refaei · Accepted solution]

The way you are trying to create the model is not going to work.

You may consider some other options like:

1. Make the second relationship inactive and activate it by USERELATIONSHIP function in your measures whenever needed.

2. Create a new table with the distinct Projekt_ID and use in a a straighforward star schema.

In Modeling, Create New Table

ProjektIDs = DISTINCT ( 'Table 1'[Project ID] )

[kala2]

Thanks added the table and made the one-to-many relationship.