Is Not Like Similar comand in dax

[Anonymous]

Hi, 
i need dax funtion  for filter a colunm.
i making type

Telefones Validos Fora HubSpot =

CALCULATE(

COUNT(

FEEGOW[celular]

),

FILTER(

FEEGOW,

NOT(ISBLANK(FEEGOW[celular])

&& NOT(SEARCH("0000",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("1111",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("2222",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("3333",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("4444",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("5555",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("6666",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("7777",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("8888",FEEGOW[celular],,BLANK()))

&& NOT(SEARCH("9999",FEEGOW[celular],,BLANK()))

&& LEN(FEEGOW[celular])>=10

&& LEN(FEEGOW[celular])<=15

&& NOT(SEARCH("_",FEEGOW[celular],,BLANK()))

)

),

NATURALINNERJOIN('Base Fora HubSpot',FEEGOW)

)

But it doesn't filter correctly

[lbendlin]

@Anonymous 

Flip your logic around, use OR instead of AND

Invalid =

SEARCH("0000",FEEGOW[celular],,0)
+ SEARCH("1111",FEEGOW[celular],,0)
+ SEARCH("2222",FEEGOW[celular],,0)
+ SEARCH("3333",FEEGOW[celular],,0)
+ SEARCH("4444",FEEGOW[celular],,0)
+ SEARCH("5555",FEEGOW[celular],,0)
+ SEARCH("6666",FEEGOW[celular],,0)
+ SEARCH("7777",FEEGOW[celular],,0)
+ SEARCH("8888",FEEGOW[celular],,0)
+ SEARCH("9999",FEEGOW[celular],,0)
+ SEARCH("_",FEEGOW[celular],,0) > 0
|| LEN(FEEGOW[celular])<10
|| LEN(FEEGOW[celular])>15