![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=1738885212-Xd8BjVKLDNx4cDwCOVdsyuROl6Z26TBE-0-c11c49547e7162c72d80dcd0acfc4409)
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=1738885212-N6fO3cpH5T21O5H3dmeVNlUr18sw9PRB-0-c140a651b090dc79efd0f69b9f53ba2f)
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.