Dimension Table Records Reduced When Linked To Fact Table

[Greg_Z]

Hello,

I am having an issue where one of my dimensions are being limited based on the fact tables it is linked to.  For example, I have an Item dimension that has a one-to-many relationship connected to a Sales Line, a Posted Sales Shipment Line, a Posted Sales line, and a Posted Credit Memo Line fact table.  The Posted Sales Shipment Line is filtred to only show lines that have been shipped not invoiced (this means that I am seeing 0 items up to 8 items).  This is causing an issue when using the Item dimension table as a slicer filter because I am only seeing items that are in the Posted Sales Shipment Line fact table instead of all items in the Item dimension table.  Does anyone know of a way to resolve this issue?  Is this an known issue?  I have not experienced this before with a slicer.

[HotChilli · Accepted solution]

Possibly the relationship direction is both ways instead of single.  I would need to see a picture of the model.

[Greg_Z]

Thank you very much! I have never had a One-To-Many set the relationship direction to both, so I did not think to check that. I appreciate it!

For others to see this is the relationship direction HotChilli referred to.