Multiple Contains value

[Niraj_vora0106]

Hi community,

Is there a way to add muiltple values in "Does not contain" under Text Filters? 

I know we can Add multiple clauses in Power or Transform Query but I'm asking in Table View or Data View 

All I'm able to do is filter it by one value. 

Any idea or info on how to filter it by multiple values in Text filters?

[Samarth_18]

Hi @Niraj_vora0106 ,

You can create a  measure with below code and use it as filter on your visual:-

Measure =
IF (
    NOT ( CONTAINSSTRING ( MAX ( table[Value] ), "search value 1" ) )
        || NOT ( CONTAINSSTRING ( MAX ( table[Value] ), "search value 2" ) )
            || NOT ( CONTAINSSTRING ( MAX ( table[Value] ), "search value 3" ) ),
    1,
    0
)

Thanks,

Samarth

[amitchandak]

@Niraj_vora0106 , refer if these 2 can help

https://www.youtube.com/watch?v=5dxbW5bswA0

https://www.goodly.co.in/filter-data-with-multiple-criteria-power-query/