Forum Discussion

Well-Mart's avatar
Well-Mart
Regular Visitor
2 years ago
Solved

Filter a table based on a temporary filtered other table

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]

 

 

  • 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] ) )
    )

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    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's avatar
      Well-Mart
      Regular Visitor

      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.