Forum Discussion
Losing values using one sided columns
Working with tables related like this is bound to be challenging. I'd recommend taking a step back and trying to set up a cleaner star schema model with dimension tables set up so that you don't have composite keys for relationships.
Super UserWorking with tables related like this is bound to be challenging. I'd recommend taking a step back and trying to set up a cleaner star schema model with dimension tables set up so that you don't have composite keys for relationships.
I have these 2 tables, and created a FactTable, but still using composite keys to link them.
When filtering by a column that exists in both tables i got these values.
When filtering by a single sided column i got these
I read the article that you shared, but can't imagine a better way to solve this.