Forum Discussion
Solved
Matrix filter has bug issue?
I set the filter on the warehouse to count both the purchase orders and the purchase order lines; however, the count on the purchase orders is not changing regardless of the warehouse selection. I'm...
- Hi,
As I refered when you create a relationship 1 to many the directionality of the filters is from the one side to the many.
The table on the many side can be filtered by any field on the one side but the contrary is not true. For making that you need to have bi directionality on, but having it turn on it will also affect other calculations.
You can activate the bidirectionality using the CROSSFILTER function so making it possible to make the filter from the many side to the one side of the relation.
Enjoy your weekend.
Regards
MFelix.
https://onedrive.live.com/?id=8C3C9A9D28C3A646%21104&cid=8C3C9A9D28C3A646
Hope you guys can open this link to access the pbix file
Hi tracyhopaulson ,
It's not available. is asking a login. Can you share in a different way?
Regards,
MFelix