Forum Discussion
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 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?
2 Replies
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
