![Microsoft Power BI Complete Reference](https://wfqqreader-1252317822.image.myqcloud.com/cover/84/36699084/b_36699084.jpg)
上QQ阅读APP看书,第一时间看更新
Enabling filtering from the many side of a relationship
To enable cross-filtering, click on Manage Relationships from the home ribbon; this will launch the manage relationship editor. Find the relationship between FactInternetSales and DimCustomer, and then click Edit.
Once the relationship editor has launched, change the cross-filter direction from single to both:
![](https://epubservercos.yuewen.com/644FAD/19470384001518306/epubprivate/OEBPS/Images/7097a59e-48fb-4f67-aff6-b5a542681dab.png?sign=1739279424-96kgMdA3OCmKLyowU1Yr2yniSE2Oyau1-0-96a34995585bba3812b2f1436ff28bb1)
Figure 14- Changing the Cross filter direction
Back in the report view, you will now see the correct customer count for each product:
![](https://epubservercos.yuewen.com/644FAD/19470384001518306/epubprivate/OEBPS/Images/d4260d09-dd67-473d-91ea-c8a5dcadd1c3.png?sign=1739279424-6jBlj44UuVvNMtFzz86AsR0uNm4YUnxP-0-d585d3e60b58c8bd96c347b93069a277)
Figure 15-Customer Count for each product
Do not enable cross-filtering for your date table. In order for some DAX calculations to work properly, the date table must have a contiguous range of dates.