Select column 1 value and then filter table based on that data's column 2 value

[Anonymous]

My data looks like this :

ID	Name	Type
1	ZZZ	Car
2	PPP	Bus
3	AAA	Car
4	RRRR	Car
5	AAAA	Train

I have to give user the option to select IDs (I've used a slicer drop down) and based on the selection of ID

All the product of similar type need to be displayed. 

For example if user selects 3, output should be

ID	Name	Type
1	ZZZ	Car
3	AAA	Car
4	RRRR	Car

Thanks!

[Zubair_Muhammad]

Hi @Anonymous

Try this technique

Assuming yoir Table's Name is Table1

First create a calculated table from Modelling Tab. This will be used as slicer

ID For Slicer = Values(Table1[ID])

Now create a Measure

Measure =
VAR selectedids =
    VALUES ( 'ID For Slicer'[ID] )
VAR myType =
    CALCULATETABLE (
        VALUES ( Table1[Type] ),
        FILTER ( ALL ( Table1 ), Table1[ID] IN selectedids )
    )
RETURN
    IF ( VALUES ( Table1[Type] ) IN myType, "Yes", "N0" )

Now Use this MEASURE as VISUAL filter

[Zubair_Muhammad · Accepted solution]

@Anonymous

Please see attached file with your sample data

[timklein]

Thanks @Zubair_Muhammad  also helped me! What to change if I want to select two IDs at the same time?

[Anonymous]

Isn't it the same as SELECTEDVALUE finction ?