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.
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?
Solved! Go to 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] )
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] )
Thanks added the table and made the one-to-many relationship.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |