Filter with text contains with AND Logic

Hi Jayaselvan 
Please refer to attached sample file with the solution

Filtered Value = 
VAR SelectdBrands = VALUES ( Brands[Brand] )
RETURN
    SUMX ( 
        VALUES ( 'Table'[brand] ),
        VAR CurrentBrands = 'Table'[brand]
        VAR String1 = SUBSTITUTE ( CurrentBrands, "[", "" )
        VAR String2 = SUBSTITUTE ( String1, "]", "" )
        VAR String3 = SUBSTITUTE ( String2, "“", "" )
        VAR String4 = SUBSTITUTE ( String3, "”", "" )
        VAR String5 = SUBSTITUTE ( String4, " ", "" )
        VAR Items = SUBSTITUTE ( String5, ",", "|" )
        VAR Length = COALESCE ( PATHLENGTH ( Items ), 1 )
        VAR T1 = GENERATESERIES ( 1, Length, 1 )
        VAR T2 = ADDCOLUMNS ( T1, "@Brand", PATHITEM ( Items, [Value] ) )
        VAR T3 = SELECTCOLUMNS ( T2, "@@Brand", [@Brand] )
        VAR T4 = INTERSECT ( T3, SelectdBrands )
        RETURN
            IF ( COUNTROWS ( SelectdBrands ) = COUNTROWS ( T4 ), CALCULATE ( SUM ( 'Table'[value] ) ) )
    )