Count the volume of "contact_no" only when it contains specific records

[Dan492813]

Hey all, I'm trying to only count the number of "contact_no" where any of the actions (they all start with "C200" ) appear within that record. 

If it doesn't contain any "C200" I dont want it to count them.

Count stage 2 = CALCULATE(COUNTAX(hgmcntct,hgmcntct[contact_no]), FILTER(hgmcntac, hgmcntac[action_cd] = "C2001" || hgmcntac[action_cd] = "C2002" || hgmcntac[action_cd] = "C2003" || hgmcntac[action_cd] = "C2004" || hgmcntac[action_cd] = "C2005" || hgmcntac[action_cd] = "C2006" || hgmcntac[action_cd] = "C2007" || hgmcntac[action_cd] = "C2008"))

Thanks, Dan

[tamerj1 · Accepted solution]

Hi @Dan492813 
Please try

Count stage 2 =
SUMX (
    VALUES ( hgmcntct[contact_no] ),
    IF (
        NOT ISEMPTY (
            FILTER (
                CALCULATETABLE ( VALUES ( hgmcntac[action_cd] ) ),
                CONTAINSSTRING ( hgmcntac[action_cd], "C200" )
            )
        ),
        1
    )
)

[Dan492813]

You're a star tamerj1 as always.