Filter Function with "Not Contains"

Question

Hi All,Any help would be appreciatedI already have a formula in place , I just want to add third condition to this:First Condition : - if status =1Second Condition : - Total time for same A values &gt; 5 minThird condition is(this is needed)&nbsp; : - for same values of A column, values of column C does not contain string ACL or BCL&nbsp; string in itSelectColumns(Filter(Table1, status=1 &amp;&amp;&nbsp; Total Time&gt;5 min &amp;&amp; "third condition here" ),"A", A,"B", B,"C", C,'Status", Status,"Duration", Duration)&nbsp;Sample Data:Result Table:&nbsp;&nbsp;&nbsp;&nbsp;

toddchitt · Answer

Yoiu will want to investigate the CONTAINSSTRING DAX function:
CONTAINSSTRING function (DAX) - DAX | Microsoft Learn
And wrap it in a NOT (&nbsp; ) funciton:
Filter(Table1, status=1 &amp;&amp;&nbsp; Total Time&gt;5 min &amp;&amp; NOT ( CONTAINSSTRING ( [C] "ACL" ) ),
(Not 100% sure of the above. Do your own researsh and testing, please.)
Hope this helps
&nbsp;

anonymous · Answer

Thanks&nbsp;ToddChitt&nbsp;I tried this one already but I want the condition which says for any C values of Same "A" column value that does not contain "ACL" or "BCL"&nbsp;so here I should probably use Allexcept but that's not working.&nbsp;

ahmedoye · Answer

Hi, you can modify the Filter side of your formula as below:Filter(Table1, status=1 &amp;&amp;&nbsp; Total Time&gt;5 min &amp;&amp;(FIND("ACL", Table1[C], 1, 0) = 0 || FIND("BCL", Table1[C], 1, 0) = 0))If this works for you, kindly mark as solution to make it easier for anyone with similar challenges find the solution.&nbsp;

toddchitt · Answer

Sorry, I don't quite understand the comparison logic. Can you explain in plain language the relationship between A and C and what would, or would NOT, make a row acceptable or unacceptable.

anonymous · Answer

So A here is ID -&nbsp;for same 1002 we have different C column Values, the idea here is if any of the C column for same value of A column has ACL or BCL it should not be in the result.

Forum Discussion

Related content

Dataflow fails with error "contains invalid characters. ",;{}()\n\t=" are not supported"

DAX SWITCH not contain "*"

CountX with string does not contain "."

Measure with "does not contain" and/or "is null"

Power Query - "Contains" not working with "List of Parameter"