Dealing with multiple relationships

While it is possible to create multiple relationships between tables, only one of them can be active at a time. A classic example of this is where you have several dates in a data table, all of which are related to a single date in a date table. In the example shown in Figure 6-2, we have two date fields in the Sales table, both of which are joined to the Date table. The active relationship shown here is between the Date[DateKey] and Sales[SalesDateKey] columns:

Figure 6-2: Multiple relationships between tables with active relationship highlighted

Figure 6-3 shows the second relationship between the Date[DateKey] ...

Get Hands-On Business Intelligence with DAX 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.