Forum Discussion

bendsteel6's avatar
bendsteel6
Helper I
2 years ago
Solved

Filter with Multiple Contains and 'Not Contains'

Hi, I'm trying to create a measure that will show me the number of records where:   OTHER_COST_DESC contains either '23917401' or '24546941' but DOES NOT contains 'FREIGHT'.   I'm trying to use ...
Need Help
  • NishPatel's avatar
    NishPatel
    2 years ago

    Please try below measure,

    Num_EGR_CLAIMS =
    CALCULATE (
    COUNTROWS (
    FILTER (
    OTHER_COSTS,
    OTHER_COSTS[OTHER_COST_DESCRIPTION] <> "FREIGHT"
    && ( OTHER_COSTS[OTHER_COST_DESCRIPTION] = "23917401"
    || OTHER_COSTS[OTHER_COST_DESCRIPTION] = "24546941" )
    )
    )
    )

bendsteel6's avatar
bendsteel6
Helper I
2 years ago

Yes!  It works!  Thank you NishPatel.  I've accepted this as the solution.