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.
Hi Team,
Below is the relationship that i have in PowerBI Data model.
Table 1-
- Invoiced Sales
- CustomerID
Table 2
- CustomerID
Table 3
- TerritoryID
Table 4 - (Bridge table)
- CustomerID
- TerritoryID
Table-1 is linked with Table-2 based on CustomerID
Now issue is i'm facing -- if we do not have any records in Table 4 (bridge table) - No data is being displayed from Table-1 (inner join with Table2)
but I need to show the records from Table-1 (basically Left join) irrespective of CusomerID present in Bridge Table.
Need your help please.
Regards,
Solved! Go to Solution.
The simplest fix here is probably to add any missing customer ids into your bridge table and just leave the Territory ID blank
Hi @Anonymous
Please kindly help mark the above answer as solution if it helps, others will benifit from it. thansks!
The simplest fix here is probably to add any missing customer ids into your bridge table and just leave the Territory ID blank
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |