Relationship doesn't work towards 4th table

[Alanbo]

Hi, 

I have a minor issue with one of my reports.

I have 4 tables connected through relationships, but only one link between each of them.
But the data between the 1st and the 4th table is not dynamic. how do i connect these tables?

Connecting the 1st " 04 FunctionTargets" and the 4th "08 Scrap reason codes" doesn't seem to solve the issue 

[v-lili6-msft · Accepted solution]

hi, @Alanbo 

1. If you want to the data between the 1st and the 4th table is dynamic,

you should keep all the cross filter direction is "Both"

2. for your data model, 10 and 08 is dim fact table and 04 and 07 are data table, the best data model should like this:

Then use all the dim fields from10 and 08 tables in visual and for filter.

Best Regards,
Lin

[Alanbo]

Hi, 

Thank you, I have it working now