Bidirectional relationships

Bidirectional cross-filtering enables the filter context of a table on the many side of a relationship to flow to the one side of the relationship. Prior to support for bidirectional relationships, equivalent filter behavior commonly used in many-to-many relationships was only possible via DAX expressions. A common use case for bidirectional relationships is represented in the following data model:

Bidirectional cross-filtering for a many-to-many relationship

In this model, a customer can have many accounts and an individual account can be associated with many customers. Given the many-to-many relationship between ...

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.