and logic in slicer

[maheshdeshmukh]

i have table 

State	city
maharashtra	pune
maharashtra	mumbai
maharashtra	aurangabad
gujarat	pune
gujarat	delhi
gujarat	hyderabad

in visual pane

i have slicer on city  if i am selecting two city or multilple city from slicer  in table visula i want state having all selected city 
for example if i am selecting pune,mumbai then i am getting both state but i need only maharashtra in which two city are present
how can i achive please help

[lbendlin]

If a city exists in multiple states you need to disambiguate them via a composite key.