Can't find related data using relationship spanning across multiple tables

[Anonymous]

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"

[Anonymous]

HI @Anonymous,

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

[Anonymous]

@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.

[amitchandak]

@Anonymous , 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