![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=1739674859-Fnnjfvb4jpRFpXGimVTbJccyNwErbUH4-0-6d8208e1a72788301933e1161db9c7a2)
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=1739674859-HWBeCrshH9c8HiJRkDRLyZ1Y3jublWD6-0-dbf60708533ec89aa287d365f3a39ca2)
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.