Controlling Multiple Name Columns with One Master List Column

Thank you for your reply , vanessafvg . Here I have a idea in mind, and I would like to share it for reference.

Hi Greenleaf ,

Based on your description, l created simple data.

MainQuery

EmployeeList:

Please follow the steps below:

1.Create two measures:

Consents =CALCULATE ( COUNTROWS ( MainQuery ), MainQuery[Consented] = 1 )

Deferrals = CALCULATE( COUNTROWS(MainQuery), MainQuery[Deferral] = 1)

2.Create two new tables:

Table 1 = SUMMARIZE('MainQuery','MainQuery'[ApproachedBy],"Consents",'MainQuery'[Consents])

Table 2 = SUMMARIZE('MainQuery','MainQuery'[SuitabilityBy],"Deferrals",'MainQuery'[Deferrals])

3.Then create relationships between new tables and EmployeeList as follows:

4.Create two tables using the fields of new tables, and add a slicer to your report using EmployeeList[FullName], the final results are as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!