Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

My data looks like this :

 

IDNameType
1ZZZCar
2PPPBus
3AAACar
4RRRRCar
5AAAATrain

 

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

 

IDNameType
1ZZZCar
3AAACar
4RRRRCar

 

Thanks!

Need Help

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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