Forum Discussion
Adding a certain field into my Table Visualization creates duplicated rows
- 5 years ago
Hi Icey,
Sorry for not getting back to you more quickly. I took a second look at my relationships, and I'm really not quite sure what could be done differently, and I couldn't find time to replicate my model without sensitive data.
But I did find a solution, although I'm not sure if it would be considered best practice; I right-clicked "Status" in the field list, and selected "First". This correctly shows the singular status for each Market/SKU pair, which I find odd because the status is defined by the Market/SKU pair, so I'm still not quite sure why it was originally disregarding that association and just duplicating the rows (one for each unique Status).
Hi Funk-E-Guy ,
This may be caused by the relationships among your tables.
Could you share us a dummy .pbix file for test? Please don't contain any real data or sensitive information. In addition, it is suggested to upload your file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.