That is due to one to many relationship between the tables
follow the below link:
LOD calc help you to remove the duplicates
Hope this helps
Plz mark this answer as correct or helpful to close the thread
FYI the screenshot you used is from an older version of the documentation and doesn't mention LOD expressions which are in general the easiest way to resolve these issues. (The documentation link you provided does mention LOD expressions).