Relationship issue

[sshweky]

Hi Everyone - I've been on trial and error for 3 days & I cannot fix this! Here's the situation:

I have 2 divisions in my company and I am trying to track sales, inventory, on order, in production & chargebacks from the customer. I created a table called 'year' that would connect to all the tables to filter out a specific year.

SEE TABLE STRUCTURE & VISUALIZATION BELOW. 

The problem is that when I filter out by division or specific customer, the fields from the 'Chargebacks' table go BLANK and I kow they are not blank. There is definitely a relationship issue but I cannot figure it out.  Please help!!!!!

If you want to talk by phone let me know. THANK YOU!!!!!!!!!!!!!!!!!!!!!!

[Kieran · Accepted solution]

Hi,

I may be able to help, but I can't read the text in your model. Can you resend so I can read it please and I will try and help you.

Kind Regards,

Kieran.

[sshweky]

I think I figured it out. Thanks!

[rich_solomon]

So what was the issue, and how did you solve it?

[sshweky]

I was creating 2 way relationships with everything which I didn't understand. When I switched to single, everything started working

[kcantor]

Quick tip: Put your lookup tables at the top, your bridge tables in the middle, and the fact tables at the bottom. This will help you visualize how filters flow downhill and allow you a better view to organize your relationships. I also make my lookup tables (or bridge tables) smaller so that I know at a glance which type of table it is. I only offer this advice because that is a massive model.