Data extensions beyond 2 levels of relationship to the source DE are not available to use within data filters
Trailblazer Community

Data extensions beyond 2 levels of relationship to the source DE are not available to use within data filters

Marketing Cloud Email Studio

Last updated 2020-01-16 ·Reference W-5137265 ·Reported By 5 users

In Review

Summary
When creating a Data Filter, the filter will include any Data Relationship touching the source Data Extension, and any Data Relationship touching the Data Extension connected by the source DE Data Relationships, but no further. Any Data Relationships beyond that will be ignored and any fields in the Data Extensions they connect will not be listed.

Repro
Best explained with visuals-
http://image.s6.exacttarget.com/lib/fe9813707564017a71/m/1/b31f5a6e-8005-4e43-95db-d8a8d657edf7.jpeg

Workaround
Use query activities rather than data filters and data relationships in all cases.

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.