implementing where on slicer

MP_123  Really interesting problem.

The solution I come up might not be ideal due to performance issues but major problem is that I cannot sum the total amounts ( you will understand later ).  I am posting anyway since someone can optimize or modify it to work correct.

I tried only work with formula as there might be options with data modelling.

If you need to filter a table the measure works ( exept totals ) , credit to @powerpivotpro for the post containsx 

http://www.powerpivotpro.com/2014/01/containsx-revisited-what-was-the-match/

Table with unique items called 'Items'

OneItem
milk
jam
bread

Table with mixed items called 'Many'

Mixed	Amount
milk,jam	1
jam,bread	1
jam,milk	1
bread,milk	1
milk,bread	1
jam,milk,bread	1

No relantionship between tables

We visualize a table with Many[Mixed] on rows and Many[Amount] as values, also add slicer from Items table

*Limitation 1 = Have to select only one Item in slicer.

Create new measure 

ContainsItem = 
IF (
    HASONEVALUE ( Items[OneItem] );
    SUMX (
        FILTER (
            Many;
            CONTAINS (
                ADDCOLUMNS (
                    SUMMARIZE ( Many; Many[Mixed]; Many[Amount] );
                    "WhatItem"; FIRSTNONBLANK (
                        FILTER (
                            VALUES ( Items[OneItem] );
                            SEARCH ( Items[OneItem]; Many[Mixed]; 1; 0 )
                        );
                        1
                    )
                );
                [WhatItem]; VALUES ( Items[OneItem] )
            )
        );
         Many[Amount] 
    )
)

Then add the [ContainsItem] measure in table..Filter on 'Jam'

and the table shows only rows containing Jam

Filter on 'Bread', different rows

As you noticed the totals don't work correct. I was trying to work it out but run out of time now. 

Hopefully someone of the community with more knowledge can help.

Another try I made with variables & INTERSEPT ( with the same results ) is

ContainsItem3 = 
IF (
    HASONEVALUE ( Items[OneItem] );
    
    VAR TableWithMatchItem =
        FILTER (
            Many;
            CONTAINS (
                ADDCOLUMNS (
                    SUMMARIZE ( Many; Many[Mixed] );
                    "WhatItem"; FIRSTNONBLANK (
                        FILTER (
                            VALUES ( Items[OneItem] );
                            SEARCH ( Items[OneItem]; Many[Mixed]; 1; 0 )
                        );
                        1
                    )
                );
                [WhatItem]; VALUES ( Items[OneItem] )
            )
        )
    RETURN
        SUMX(INTERSECT ( Many; TableWithMatchItem );Many[Amount]) )

ankitpatira and also, as i know so far, in the report filters you can only define measures