Forum Discussion
Solved
Losing values using one sided columns
Hello, I have two tables like this. Table A TYPE PRODUCT VALUE A DATE KEY TYPE 1 PRODUCT A 10 01/10/2021 (TYPE+PRODUCT+DATE) TYPE 2 PRODUCT A 20 01/10/2021 (TYPE+PRODUCT+...
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.