Wrong data connection

[HitcH]

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_...

Anyone can help me?

Thanks a lot!!!

[mlsx4]

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:

A	aa
B	bb
C	cc
D	dd
E	ee
F	ff
A	aa
A	aa
C	cc
F	ff
A	ff

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

[HitcH]

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):