Forum Discussion

Niraj_vora0106's avatar
Niraj_vora0106
Helper III
4 years ago

Multiple Contains value

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 Vi...
Need Help
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

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