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
4 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é

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

    Please provide sanitized sample data in usable format (ideally a pbix) and show the expected outcome.

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

      Hello lbendlin 

       

      So sorry for delay, I've had some personal issues that kept me aside.

       

      Back on topic though. Link  to test example: https://we.tl/t-YtkMRwjXw8

       

      The image below contains that only from table 1 - F_Production_Order. Notice how it has 3 Orden de Produccion.

      Once I had a field from table 2 - F_Production_Defect, Orden 79440661867 disappears. This is because that record does not exist on table 2, which is normal.

      If I set "Show Items with no data" it appears but with no value for Producido (m3) measure.

      The expected result should have with the Producido (m3) value and in my opinion without the need to show items with no data.

      How am I supposed to get that result?

      I am getting wrong data due to this behaviour.

       

      Best regards,

      André