Forum Discussion

HitcH's avatar
HitcH
Helper II
2 years ago

Wrong data connection

Hi everyone

I have three tables

Table 1 -> Document number and document value

Table 2 -> Document number and customer

Table 3 -> Customer and customer detail

 

Tables are connected this way:

 

And I want to show Customer detail and document value, but it is just not working.

Here the link to download a sample pbi:

https://we.tl/t-vzTag0FiT8?utm_campaign=TRN_TDL_05&utm_source=sendgrid&utm_medium=email&trk=TRN_TDL_05

 

Anyone can help me?

 

Thanks a lot!!!

Need Help

2 Replies

  • mlsx4's avatar
    mlsx4
    Memorable Member
    2 years ago

    Hi HitcH 

     

    Your Power BI is working fine (removing the first row of table 2 and 3 for sure). But the problem is that if you don't have any kind of index column or date to distinguish data, so it will work in the way it is doing.

    If you include in your Document Customer the last line, you get this:

    Aaa
    Bbb
    Ccc
    Ddd
    Eee
    Fff
    Aaa
    Aaa
    Ccc
    Fff
    Aff

     

    Anyway, I don't really know what you are trying to achieve

    • HitcH's avatar
      HitcH
      Helper II
      2 years ago

      I'm trying to achieve a table that only includes customer detail (big medium and small) and value.

      If I add the document inside the table it is working, but in my real data base I have over 3.000 documents, so I cannot read such a huge table, I just need to summarize them by "customer detail" field.

      I'd like to only see this (but with the correct values of course):