Microsoft Power BI Cookbook
上QQ阅读APP看书,第一时间看更新

Many-to-many relationships

In the following many-to-many model, multiple customers are associated with a given account and some customers have multiple accounts:

Many-to-many model with single direction cross-filtering relationships

Given the highlighted single direction relationship from Accounts to the CustomerAccount bridge table, a filter selection on the Customer dimension does not filter the Transactions table.