Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Two related fields on the same table but several tables missing both related fields



I'm experiencing this issue when arriving at the totals for my report. I currently have several tables that are connected by the same related field (many-to-many) called Employee ID. However, I'm hoping to display the account (many-to-many) totals for each of these employees based on an account ID. At the moment my results are giving me the total Employee ID amounts for each account so for example: 







I'm wondering if this is an data model issue or is there another root cause? I considered merging the Account Revenue Files and Sales Pipeline Files into a new query but thought there might be a better resolution.


Thank you!


Frequent Visitor

I did want to avoid merging the tables, using seperate tables gives me the current results included above. 

Super User
Super User

Maybe merging these tables give this output. Try using separate tables.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors