Filtering visuals using slicer that contains string from a different table

[Xairan]

Hello,

I have two tables - a table with a Project List and a table with a Stakeholder register and each stakeholder is aligned with multiple projects. On the stakeholder dashboard I'm trying to use a slicer with just the Project name to filter some stakeholder visuals however I'm unable to create a correct relationship between the two tables to enable this.

Table 1: Project list

Project name

Project 1

Project 2

Project 3

Project 4

Project 5

Table 2: Stakeholder register

Stakeholder name	Project name
Stakeholder 1	[List] e.g. [Project 1; Project 4]
Stakeholder 2	Project 2; Project 3
Stakeholder 3	Project 1; Project 2; Project 3; Project 5
Stakeholder 4	Project 3; Project 5

I have tried the extracting values to new rows as the Project name is a SharePoint list and creating a many to one relationship between the two tables. While this works - I've also got issues as this duplicates stakeholders which messes up with the count of stakeholders etc.

I have also tried using a filter measure: https://community.fabric.microsoft.com/t5/Desktop/Multiple-Contains-Filters-using-Visual-Filters/m-p... however while this works for data tables I'm unable to apply it with other visuals such as column graphs, card visuals etc. 

Is there a way to either generate a relationship between these two tables so the slicer works, or is there a filter measure I can apply to other visuals?

Thanks!

[Xairan]

Thank you! Turns out I did solve it. I just added in a calculated column flagging each unique name using this https://community.fabric.microsoft.com/t5/Desktop/Need-Flag-for-every-unique-value/td-p/438947 and created a filter on the page where that column equaled to 1.

[HotChilli · Accepted solution]

You've solved it already. "While this works".  The problem with duplicated stakeholders is not a problem.  This is how databases work.  You adjust any other measures to cope with this.