Forum Discussion
Matrix filter has bug issue?
- 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.
Hi tracyhopaulson ,
Making the test on your file the table on the rigth that is based on the table that as the wharehouse so it changes values when you picl the wharehouses, regarding the first table that is based on the Purcharse Orderds, that doesn't have any wharehouse except for the connection from the order lines tables, since this is one side from the relationship and the filter is from this table to the orderlines when you filter on wharehouse the result doesn't change.
This is because the filter is only from the Purchase orders to the Purchase order lines so any filter made on the second table will not affect the first one.
You need to create a bi-directionalty between the two table to have this working, however this can give you strange results best way is to create the following measure:
PO count = CALCULATE(COUNT(PurchaseOrders[PO]);CROSSFILTER(PurchaseOrderLines[PO];PurchaseOrders[PO];Both))
And used it on your table on the left, insetad of the column PO, what I'm doing here is activanting the bi-directionalitty of the filter and making it possible to filter from line order to purchar orders.
Check PBIX file attach redone.
I have added a table with the measure and kept your two other table so you could see the difference (one with yellow line around is with the measure).
Regards,
MFelix
MFelix I see what you did and still scratch my head on this one! I thought I joined the tables using the PO# as the blending source value, and therefore should be able to filter on the warehouse for the counts based on the relationship. Thank you for the formula... I still need some time to digest this. Have a great weekend :-)
- 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.
