In our data model, all our tables have single relationships between other tables. Indeed, it’s only possible to have one active relationship between any two tables, but you can have as many inactive relationships as you want. In this chapter, you will learn how to use multiple relationships between tables and activate inactive relationships. This may be because you require multiple links from a dimension table into the fact table. However, there is another less obvious ...
14. Working with Multiple Relationships Between Tables
Get Up and Running with DAX for Power BI: A Concise Guide for Non-Technical Users now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.