COUNTROW with a Containing a Letter in a Word

[Anonymous]

VAR Blank_ID = CALCULATE(

COUNTROWS(D_Eng_Win),

ISBLANK(D_Eng_Win[atl_workfrontrefid]) = TRUE()

)

What if I want to count rows like I did above but instead of looking for blank I want to count any word that contains the letter N?

Can I make it case sensative?

[themistoklis · Accepted solution]

@Anonymous 

Tr the following formula:

MEASURE FindN =
    CALCULATE (
        COUNTROWS ( D_Eng_Win ),
        FILTER (
            D_Eng_Win,
            SEARCH ( "N", D_Eng_Win[atl_workfrontrefid],, 0 ) <> 0
                || SEARCH ( "n", D_Eng_Win[atl_workfrontrefid],, 0 ) <> 0
        )
    )