Single-direction relationships

Single-direction cross-filtering relationships are the most common in Power BI datasets and particularly for data models with more than one fact table. In this dataset, whether import or DirectQuery, all relationships are defined with single direction cross-filtering except for the relationships from Sales Territory, Product, and Date to their corresponding bridge tables, as described in the following section on bidirectional relationships.

The following screenshot from the Relationships View includes three of the seven dimension tables related to Reseller Sales:

Single-direction relationships

As you can see ...

Get Mastering Microsoft Power BI 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.