Count rows containing string from other table column

Hi,

I already tried some solutions ( like CountRows where column A contains a string and col... - Microsoft Fabric Community or Solved: Count rows containing value - Microsoft Fabric Community ) but that didn't help me.

My report has (in short) two tables:

Table 1: OwnerUnique

Columns:

• owner_mail: contains a single mail address per row as string

Table2: final_output

Columns:

• owner_final: contains a string with multiple mail adresses separated by comma
• virtual_path: an url as string

What do I need/want:

In a table visual I want to

• list all OwnerUnique[owner_mail]
• count all rows in table final_output where column [owner_final] contains the value from OwnerUnique[owner_mail]

At the moment the visual only counts these rows where the mail address is the only value but rows with multiple addresses are aggregated into a blank value in the visual.

My measure looks like this:

Kennzahl = CALCULATE(
COUNT(
final_output[VirtualPath_final]), 
FILTER(final_output, CONTAINSSTRING(final_output[owner_final], SELECTEDVALUE(OwnerUnique[owner_mail]))
)
)

Do you have any hinbts or ideas how to solve it?

Best regards