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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.