Forum Discussion
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 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!
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" )
)
)
)
2 Replies
- bendsteel6Helper I
Yes! It works! Thank you NishPatel. I've accepted this as the solution.
- NishPatelResolver II
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" )
)
)
)