Count row if cell cointains text from another table

[borone]

Hello,

I have two tables.

Table 1. contains names that aren't well written.

Table 1
Names
Ped
Luc
Dyla
Fiona

Table 2. contains names that are well written.

Table 2
Name
Pedro
Juan
Dylan
Dylan

What I want to achieve is create a calculated column on the first table which shows a count of repitences if table 2 contains part of the first column.

Here's my desired result:

Table 1
Name Calculated Column
Ped            1
Luc             0
Dyla           2
Fiona         0

Thanks a lot.

[Anonymous · Accepted solution]

Hi @borone ,

Please try:

Column = SUMX('Table 2', FIND('Table 1'[Names],'Table 2'[Name],,0))

Best Regards,
Eyelyn Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@borone , You can try this, but it can be really costly

new column in table 1

countx(filter(Table2, containsstring(Table2[Name], Table1[names]) ), Table2[Name]) +0