Forum Discussion
Solved
Filtering visuals using slicer that contains string from a different table
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 u...
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.
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.