Count rows containing string from other table column

Hi FabvE -  we need to refine the DAX logic to correctly evaluate rows with multiple email addresses. 

Kennzahl =
CALCULATE(
COUNTROWS(final_output),
FILTER(
final_output,
CONTAINSSTRING(
SUBSTITUTE(final_output[owner_final], " ", ""),
SELECTEDVALUE(OwnerUnique[owner_mail])
)
)
)

Alternatively, use a calculated table in DAX to create a normalized version of final_output.

Hope this works.

Hi FabvE , Tried with sample data as below : 

you can modify your dax as below : 
Measure =
CALCULATE(
COUNTROWS(final_output),
FILTER(
final_output,
NOT(ISBLANK(SELECTEDVALUE(OwnerUnique[owner_mail]))) &&
CONTAINSSTRING(final_output[owner_final], SELECTEDVALUE(OwnerUnique[owner_mail]))
)
)


Thanks, 
Ankita