Forum Discussion

DividTorte's avatar
DividTorte
Frequent Visitor
2 years ago
Solved

Issue with Joins

Hello!   I am having some issues with joins (I think) that's leading to some misrepresentation of my data. I have two tables for which I would like to join on three different variables (Name, Task/...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    DividTorte first of all it is not a best practice to have many to many relationships between tables and also cross filter direction set to both is a bad idea.

     

    The best way is to create 3 dimension tables for each column and then use that to set relationship with these two tables, and then you can easily view the data at any dimension from these tables. Learn more about star schema here. Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

DividTorte first of all it is not a best practice to have many to many relationships between tables and also cross filter direction set to both is a bad idea.

 

The best way is to create 3 dimension tables for each column and then use that to set relationship with these two tables, and then you can easily view the data at any dimension from these tables. Learn more about star schema here. Understand star schema and the importance for Power BI - Power BI | Microsoft Learn