Filter a table based on a temporary filtered other table

[Well-Mart]

Hello, everyone!
I need some help filtering tables that are not directly related.

I have this reference TABLE A - called Items. All my items are there, and the "key" is the Item Number(ArtNr);

Another TABLE B - called Orders, the "key" is also ItemNumber, and I have a visual Table to show me how many pieces per Order Number (OrderNr), based on each Item Number;

Finally, I have a third TABLE C - called Purchase (orders); the key also is ItemNumber as well, but it shows how many Purchase Order Numbers (BestNr) for each Item Number;

The problem is when I filter an Order Number (OrderNr) in [B] that has multiple Item Numbers (ArtNr), I wish it could filter the table [C]  by the same Item Numbers (ArtNr) that are shown in table [B]; the Order Number is a slicer for the table [B]

[tamerj1 · Accepted solution]

Hi @Well-Mart 

place the following measure in the filter pane of the prachse table visual, select "is not blank" then apply the filter 

FilterMeasure =
CALCULATE (
COUNTROWS ( Purchase ),
KEEPFILTERS ( TREATAS ( VALUES ( Orders[AtNr] ), Purchase[ArtNr] ) )
)

[Well-Mart]

Thank you, @tamerj1 ! It is working; the measure is counting when the Item in Purchase appears in the Orders table, then I filtered the Purchase table for not blank, and it filtered.