Create a report from two Lists-with multiple text column lookup field

Hi, Anonymous 

I'd like to suggest you create a calculated table and a measure as below. There is no relationship between tables. The pbix file is attached in the end.
Calculated table:

Table = 
CALCULATETABLE(
    DISTINCT('Manager List'[ManagerName]),
    FILTER(
        ALL('Manager List'),
        [Status]="Resigned"
    )
)

Measure:

Visual Control = 
var c = 
COUNTROWS(
    FILTER(
        DISTINCT('Table'[ManagerName]),
        CONTAINSSTRINGEXACT(MAX('Company List'[Board Managers]),[ManagerName])
    )
)+0
return
IF(
    c>0,
    1,0
)

Then you need to put the measure in the visual level filter and use 'ManagerName' from 'Table' to filter the result.

Best Regards

Allan

If this post helps,then consider Accepting it as the solution to help other members find it faster.