Can I filter two similar columns from two different tables without a relationship?
Hello there, by similar, I mean two different columns share the same values, and can work as foreign keys, only in this instance they can't. It might sound a bit bizarre. But currently I have 12 tables in this project. However, I can't build another link between these two tables because it will introduce ambiguity (I have many duo filters which I need).
Here is the model diagram shown below:
Everything here works fine and works how it's supposed to despite one limitation. I want to match the Deals (CRM) table with the Projects (Books) table. The two highlighted columns are what I want to match, they share the same name. So for example, a Project Name can be called "Table & Chairs", and Project 1 would have have the exact same value. From there, there is a link.
I want to be able to filter a Project name through a Deal in my report. Without changing any of my relationships above, because I need them to work as they are.
Hi @v-shex-msft thanks for the response but I don't know how I could remodel this into a Star Schema. The relationships have to be the way they currently are for the filters to work correctly. Otherwise the filters will not work.