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 :   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 ...
Need Help
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