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.
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.
Ideally, you'd probably want separate dimension tables for Type, Product, and Date. It's hard to make good recommendations without seeing a sample .pbix file though.
Well, thank you anyway.
I'll leave this in stand by, maybe in the near future i try again.