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 try to use relationships that span multiple tables, for example, to filter, group, or to calculate measures. For example, I want to calculate how many entries in tableE are associated with an entry in tableA.
Table Structure:
tableA: id, ...
tableB: id, tableA_id, tableC_id
tableC: id
tableD: id, tableC_id, tableE_id
Relationships: tableA 1:n tableB n:1 tableC 1:n tableD n:1 tableE
To check the relationships, I tried to create a large table (in report view) that joins tableA - tableE. It is possible to join tableA, tableB and tableC and also possible to join tableC, tableD and tableE. Joining tableA - tableE on the other hand does not work.
Left: Joined tableA - tableC | Right: Joined tableC - tableE
Trying to join tableB on joined table "tableC - tableE"
HI @Jonas_N,
In my opinion, I'd like to suggest you create a calculated table with lookupvalue and addcolumns function to lookup correspond values to create a summary table with all related table fields.
They should better performance than creating visuals from multiple table fields based on the long single chain relationships and basic visual analysis and aggregated features.
LOOKUPVALUE function (DAX) - DAX | Microsoft Docs
ADDCOLUMNS function (DAX) - DAX | Microsoft Docs
Regards,
Xiaoxin Sheng
@amitchandak thank you for your answer. But why can't I do that? From a database perspective, isn't this just a simple JOIN with multiple tables? For each entry of the left table the entry from the right table should be appended to tableC.id == tableD.tableC_id.
@Jonas_N , If there are two tables on Many sides of the center 1 table. Then you can not use unsummarized from both N side tables. You can only use it from unsummarized column from one of these tables
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 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |