Forum Discussion
Helper IIIMany to Many relationship between 3 tablesi w
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] )
Solution SpecialistThe 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] )
Helper IIIThanks added the table and made the one-to-many relationship.