Dimension Table Relationship

Hi nchamilton162 ,

To what I can see from the image you shared the fact that you are using bidirectional filters on your model is for sure part of the reason of the errors you are getting, because all tables are being filter by all tables.

Power BI works better with star schemas and the bidirectionality if needed can be recreated using measures, because the vertipac engine will be much more effective in that manner.

However only looking at the image of your relationships does not allow to give an effective answer and what is happening, and this may be due to different options.

I also have a question on why you refer that you don't want to add a measure to your table, you can use measure has a filter on your visualizations and they will impact the visual without the user be aware of their presence.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.