Relationship Issue

Anonymous — Tue, 13 Aug 2019 06:32:38 GMT

Hi All,

Here I've attached the sample of filtered information of the two tables and the output is the one that I got in PowerBI summary table. A many-to-many relationship was established between table 1 and table 2 as it was the only choice that PowerBI allowed. It was established between 'Item' on both tables.

I would like to know why am i getting such an output and what can be done to solve it.

(The count value is not set to distinct)

Thank you in advance.

Re: Relationship Issue

TeigeGao — Wed, 14 Aug 2019 02:22:04 GMT

Hi Anonymous ,

Actually, if the ID and Item in table is mapped one-to-one correspondence, it should be a one to many relationship, if they are not mapped one-to-one, one item has many ID mapped, then we cannot get the sum of ID in the result table, we will need to add the column ID to the table 2.

Best Regards,

Teige

topic Relationship Issue in Desktop

Relationship Issue

Re: Relationship Issue