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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
lw24
Helper I
Helper I

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

Hello!

 

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: 

 

lw24_0-1684526671096.png

 

lw24_1-1684526887528.png

 

 

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!

 

2 REPLIES 2
lw24
Helper I
Helper I

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

rajulshah
Super User
Super User

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.