Forum Discussion

afbraga66's avatar
afbraga66
Icon for Helper III rankHelper III
5 years ago

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 ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

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

  • afbraga66's avatar
    afbraga66
    Icon for Helper III rankHelper III
    5 years ago

    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

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

      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.

      • afbraga66's avatar
        afbraga66
        Icon for Helper III rankHelper III
        4 years ago

        Hello lbendlin ,

         

        Fair enough. Still I set it to one-to-many from T1 to T2 with direction set to single, but still happens the exactly same behaviour.

         

        Best regards,

        André