The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Here's the simple relationship. This could by my issue?
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/
Proud to be a Super User!