Help with Relationships & Filters

Hi alisonpappas ,

For the relationship, recommend you create the star schema instead of circle schema, so you may delete the secondary relationships among these tables, and change the Cross filter direction of relationships among the these tables above from Single to Both , which will take these tables treated as a single table.

You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.

If you need to combine the tables with the similar table structure, you may use merge and append feature in Query Editor, see more detail:Append vs. Merge in Power BI and Power Query , Tutorial: Shape and combine data in Power BI Desktop.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.