Forum Discussion
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/Category, and Date). When I attempt to make the join, only one of the relationships can be active? This is causing the issue below where the number of tasks comes across for the entire population, not for a specific combination of the three variables. I have checked and quadruple checked to make sure that the data types are the same between the variables. NOTE: the screenshot shows data for 4 different persons with the same exact task count.
Here is a shot of my current setup:
Thanks for your help!
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
1 Reply
- parry2k
Super User
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