How to count how many times a word appears in another column from another table

[asc002]

HI

I have two tables like following: 

TABLE 1

case no	title
1245	hchdca ads sdposdjg bcd
13446	spvsdhsdphsd ads hgkèhg
56784	sdfshpsdsd ads èrhrèr

TABLE 2:

word	count
ads	? -> the answer should be 3
bcd	? -> the answer should be 1

there is not relationship between the two tables.

How can I count how many times the value in the "word" column is present into the table 1 column "title"?

thanks for your ideas

Andrea

[asc002]

HI

thanks. what about if I would like to have it as measure?

thanks

Andrea

[Jihwan_Kim]

Hi,

Thank you for your message, and please check the below picture and the attached pbix file.

It is for creating a new measure.

Count measure: =
IF (
    HASONEVALUE ( 'Table 2'[word] ),
    COUNTROWS (
        FILTER (
            'Table 1',
            CONTAINSSTRING ( 'Table 1'[title], MAX ( 'Table 2'[word] ) )
        )
    )
)

[Jihwan_Kim]

Hi,

Please check the below.

It is for creating a new column.

Count CC = 
COUNTROWS (
    FILTER ( 'Table 1', CONTAINSSTRING ( 'Table 1'[title], 'Table 2'[word] ) )
)