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

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