Filter with Multiple Contains and 'Not Contains'

[bendsteel6]

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 this:

Num_EGR_CLAIMS =

CALCULATE(COUNTROWS(
FILTER(OTHER_COSTS,CONTAINSSTRING(OTHER_COSTS[OTHER_COST_DESCRIPTION],"23917401")

||CONTAINSSTRING(OTHER_COSTS[OTHER_COST_DESCRIPTION],"24546941")),
FILTER(OTHER_COSTS,NOT(CONTAINSSTRING(OTHER_COSTS[OTHER_COST_DESCRIPTION],"FREIGHT")))
)

but I get errors in the 'not contains' part.  I've tried so many different combinations but cannot get it ot work.  Any suggestions?

Thanks!

[bendsteel6]

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

[NishPatel · Accepted solution]

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" )
)
)
)