One to Many RelationShip

Agree with AbhinavJoshi .

You can generate a new table contains the manager ID if you don't want it to affect the count.

Here're the steps:

1.Duplicate the table.

2.Remove other columns.

3.Split the column.

4.Trim to remove the spaces.

5.Go back to power bi desktop, create a measure to make the filtering successful.

Measure = IF(CONTAINSSTRING(MAX('Table'[Reporting Managers]),SELECTEDVALUE('Table (2)'[Reporting Managers])),1)

6.Put the measure into the visual-level filters and set up show items when the value is 1.

7.Here's the result. When you select Magr2 in the slicer, the table visual only displays the reporting managers contains Magr2.

Note: There's no relationship between the new table and the main table.

Best Regards,

Stephen Tao

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