Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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!