2 Tables - show multiple options from one selection

Question

Hi&nbsp;&nbsp;I have the following two tables:&nbsp;&nbsp;Table1DLY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; DLY_REASON &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DLY_MIN2/3/2019 5:14:09AM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 125631 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LATE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 102/10/2019 7:57:63PM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 125638 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SLOW &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 82/25/2019 2:14:09AM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 127531 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LATE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 52/28/2019 5:14:09AM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 129852 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; LATE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 7&nbsp;Table2ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; CD &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TAKEN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ARRIVAL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TURNAROUND125631 &nbsp; &nbsp; &nbsp; A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2/3/2019 4:58:09AM &nbsp; &nbsp; &nbsp; &nbsp; 2/3/2019 5:01:09AM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3125631 &nbsp; &nbsp; &nbsp; B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2/3/2019 5:10:00AM &nbsp; &nbsp; &nbsp; &nbsp; 2/3/2019 5:15:00AM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5125631 &nbsp; &nbsp; &nbsp; C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2/3/2019 5:19:09AM &nbsp; &nbsp; &nbsp; &nbsp; 2/3/2019 5:26:09AM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7125632 &nbsp; &nbsp; &nbsp; A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2/3/2019 5:40:11AM &nbsp; &nbsp; &nbsp; &nbsp; 2/3/2019 5:44:11AM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4125632 &nbsp; &nbsp; &nbsp; B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 2/3/2019 5:52:41AM &nbsp; &nbsp; &nbsp; &nbsp; 2/3/2019 5:55:41AM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp;Both of these are in PowerBI as tables with a realtionship between the ID's. If I select an ID in Table1, then all instances of that ID show in Table2. How can I have Table2 show me all the instances of my selection plus the ID after it?&nbsp;EX:&nbsp; I I select the first line in Table1, I would want Table2 to show 125631 and 125632&nbsp;Thanks&nbsp;&nbsp;&nbsp;

v-yulgu-msft · Accepted Answer

Hi&nbsp;Garett52&nbsp;,
&nbsp;
You need an extra table to list all unique IDs which will be added to slicer later, this table should be unrelated to both Table1 and Table2.

Slicer Item = DISTINCT(TB1[ID])

&nbsp;
Add below measure to visual level filter.

Measure =
IF (
    ISFILTERED ( 'Slicer Item'[ID] ),
    IF (
        SELECTEDVALUE ( TB2[ID] )
            IN { SELECTEDVALUE ( 'Slicer Item'[ID] ), SELECTEDVALUE ( 'Slicer Item'[ID] ) + 1 },
        1,
        0
    ),
    1
)

Best regards,
Yuliana Gu

Forum Discussion

2 Tables - show multiple options from one selection

2 Replies

Related content

Selectedvalue() doesn't work when multiple options are selected

Multiple search options

Multiple Select option

Multiple version selection

Need Intersection results when select multiple option from Slicer