Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Filter Function with "Not Contains"

Hi All, Any help would be appreciated I already have a formula in place , I just want to add third condition to this: First Condition : - if status =1 Second Condition : - Total time for same A v...
Need Help
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

Yoiu will want to investigate the CONTAINSSTRING DAX function:

CONTAINSSTRING function (DAX) - DAX | Microsoft Learn

And wrap it in a NOT (  ) funciton:

Filter(Table1, status=1 &&  Total Time>5 min && NOT ( CONTAINSSTRING ( [C] "ACL" ) ),

(Not 100% sure of the above. Do your own researsh and testing, please.)

Hope this helps

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks ToddChitt 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"

     

    so here I should probably use Allexcept but that's not working. 

    • ToddChitt's avatar
      ToddChitt
      Icon for Super User rankSuper User
      1 year ago

      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's avatar
        Anonymous
        Not applicable
        1 year ago

        So A here is ID - 

        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.