Forum Discussion

Tanaka's avatar
Tanaka
Frequent Visitor
5 years ago
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+...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    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.

     

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

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.

 

 

  • Tanaka's avatar
    Tanaka
    Frequent Visitor
    5 years ago

    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.

     




    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      5 years ago

      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.

      • Tanaka's avatar
        Tanaka
        Frequent Visitor
        5 years ago

        Well, thank you anyway.

        I'll leave this in stand by, maybe in the near future i try again.