© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. BoxUp and Running with DAX for Power BI https://doi.org/10.1007/978-1-4842-8188-8_14

14. Working with Multiple Relationships Between Tables

Alison Box1  
(1)
Billingshurst, West Sussex, UK
 

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 ...

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.