video1.0<iframe src="https://www.loom.com/embed/ddaae4dcf3b743a9889585bc450027e3" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/ddaae4dcf3b743a9889585bc450027e3-80a142b6c6376cf5.gif267.059In this video, I walk you through the process of creating blends to establish relationships between different entities in our data tables. We specifically look at how to relate the Campaigns table to the Responses table, including handling blank values and defining the relationship between columns like Campaign ID. I explain the importance of filter settings, particularly how they affect data visibility across tables, and highlight the difference between automatic filters and one filters many. For more information on the importance of the filter direction in a relationship, refer to https://learn.microsoft.com/en-us/analysis-services/tabular-models/bi-directional-cross-filters-tabular-models-analysis-services?view=sql-analysis-services-2025.