I need help with my model

[dakins]

Hello, 

I have a star schema, and the tables below connect to the same fields on the fact table however, whenever I attempt to use fields from the two tables, I get "can't display visual" - there is a missing relationship between these fields. 

Can someone please explain what the issue is or how to fix it?

Thank you

D

[CharbelArmaleh · Accepted solution]

Hello

Sure cos the filter propagation work from 1 to many. When you are using a field from table a the filter is blocked by the many relation. Use the common field from the dimension table

[CharbelArmaleh]

Did i answer you questions? Mark my answer as a solution !