Hey guys,
I'm a bit stuck in a 1-n Relationship
Im working on a bigger PowerBi report which includes some tables directly imported and a directquery to another PowerBi Dataset
1 is imported with Excel so and the other two i have connected with DirectQuery
| Table 1 | Table 2 |
| DirectQuery | DirectQuery |
 | |
| Table 3 | Table 4 |
| Imported | Imported |
 |  |
The First two Tables are Connected over the _Fct Join Colum with a 1-n Relationship from Table 1 to table 2.
The Table 2 and Table 3 are connected with 1-n over the colums Startzeit and TimeList
So I'm able to get the Order Label form my first Table with Datum & Uhrzeit of my third Table.
Now i have added another Table ->Table 4
The Table 4 and Table 1 are connected with a 1-n ( Table1-Table4) Realtionship
Now in my Report i want to get all the Datum & Uhrzeit of my table 3, when i filter my Table 4 after a WZNummer.
Here are some tables with Data:
Table 4:
| Auftrag ID | WZNummer |
| 45727039 | 32568266 |
| 45727042 | 32568266 |
| 45737574 | 32568266 |
| 45737576 | 32568222 |
| 45737577 | 32568222 |
| 45737579 | 32568222 |
| 45737580 | 32568261 |
| 45744979 | 32568261 |
| 45744980 | 32568261 |
| 45747188 | 32568261 |
Table 1:
| _Fct Join Colum | Order Step Label |
| 0_1252655 | 45727039 |
| 0_1252918 | 45727039 |
| 0_1253163 | 45727039 |
| 0_1262976 | 45737574 |
| 0_1263275 | 45737574 |
| 0_1263555 | 45737574 |
| 0_1279016 | 45747188 |
| 0_1279248 | 45747188 |
| 0_1279379 | 45727042 |
| 0_1279594 | 45737574 |
| 0_1291667 | 45737576 |
| 0_1291952 | 45737576 |
| 0_1292204 | 45737577 |
| 0_1304480 | 45737579 |
| 0_1304714 | 45737580 |
| 0_1304922 | 45737580 |
| 0_1316566 | 45737580 |
| 0_1316615 | 45737580 |
| 0_1316642 | 45744979 |
| 0_1327922 | 45744979 |
| 0_1327952 | 45744980 |
Sorry for lots of this data, but i wanted to provide as much as i can.
Sincerely
Jonas
Hi @Anonymous ,
Now in my Report i want to get all the Datum & Uhrzeit of my table 3, when i filter my Table 4 after a WZNummer.
I can't reproduce your issue when using SQL Server as a data source.
Please check if you have prevent the filter.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
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
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
