01-17-2019 01:33 PM - edited 01-17-2019 02:48 PM
My data looks like this :
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
Solved! Go to Solution.
01-18-2019 07:21 AM
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