Forum Discussion

bgerew's avatar
bgerew
New Member
8 years ago
Solved

Multi step filter

I have 2 tables.   The first table will be filtered by date using a slicer. This will return a list of invoice numbers.   I then would like to filter the second table by those invoice numbers tha...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi bgerew,

     

    Based on my test, you should be able to use the formula below to create a measure, then use the measure to apply a visual level filter(Measure is great than 0) to filter the second table by selected value in first table.

    Measure =
SUMX (
    Table1,
    IF (
        CONTAINS (
            Table1,
            Table1[Invoice Number], FIRSTNONBLANK ( Table2[Invoice Number], 1 )
        ),
        1,
        0
    )
)

     

    Here is the sample pbix file for your reference. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi bgerew,

 

Based on my test, you should be able to use the formula below to create a measure, then use the measure to apply a visual level filter(Measure is great than 0) to filter the second table by selected value in first table.

Measure =
SUMX (
    Table1,
    IF (
        CONTAINS (
            Table1,
            Table1[Invoice Number], FIRSTNONBLANK ( Table2[Invoice Number], 1 )
        ),
        1,
        0
    )
)

 

Here is the sample pbix file for your reference. :smileyhappy:

 

Regards