Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
trsonber
Regular Visitor

Repeating values due to relationship

This is probably a simple problem but I am just getting started using PowerBI and understanding relationships.

 

Below is my incorrect report view.  Parent (Alps South LLC) repeats it's Total Estimated Commission incorrectly by the number of related Child Accounts.  My goal is the have a Single parent listed but then Child and Total Estimated Commission Child for each child account. 

I am working with two tables - Parent and Child.

Example below Alps South LLC repeats the Total Estimated Commission because it has three related Child accounts.

Capture.PNG

 

 

 

 

 

 

 

 

Here's the simple relationship.  This could by my issue?

Capture1.PNG

 

1 REPLY 1
DataInsights
Super User
Super User

@trsonber,

 

This is normal behavior with parent/child tables (parent data repeats for each child row, resulting in duplication of amounts). Here's an article that may be useful:

 

https://www.sqlbi.com/articles/header-detail-vs-star-schema-models-in-tabular-and-power-bi/ 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.