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); Ano...
  • tamerj1's avatar
    tamerj1
    2 years ago

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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

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
2 years ago

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.