Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |