Forum Discussion
Understanding - items with no data and relationships
Hi, So I have got the table below. The table visual has content from two tables - T1 and T2. The relationship between them is many to many. Line 1 of the T1 has data in T2, but line 2 of ...
You didn't specify which filter direction you chose, and which columns (from which side of the relationship) you chose. Both have an impact on your observed behavior.
If you like you can read the whitepaper here The Many-to-Many Revolution - SQLBI
Hey lbendlin
The direction is set to both.
The columns from which relationship/table is identified in the original post image by T1 and T2.
Thank you.
Best regards,
André Braga
Yeah, you can't really do that (set the filter direction to both) and expect any meaningful results. Maybe create separate versions of your data model for the different business questions.