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

View all the Fabric Data Days sessions on demand. View schedule

Reply
ViDax
New Member

Multiple relationships between two tables

Hi Everyone,

 

I am presently working on two tables,  namely Assignment Sheet (Column Names are: Task Name, Status, Loader, Checker, QC Date, QC Status) and Loss Sheet (Column Names are: Task Name, Loader Name, QC Name, QC Date, Loss Amount)

 

Now I want to calculate Month-wise Checker's Production along with the loss in a single Visualization. To do this, I have crearted a seperate Date table and creted the following relationships among them:

ViDax_0-1680000743911.png

Also, to calculate the monthly loss amount, I have created a new measure, naming 

Monthly Loss = CALCULATE(SUM('Loss Sheet'[Loss Amount]),USERELATIONSHIP('Loss Sheet'[QC Name],Assignment_Sheet[Checker]))
 
However, when I tried to get the visual, I am getting the following data:
ViDax_1-1680000934323.png

The Loss amount is getting duplicated, however the sum of the losses is correct. Kindly guide me the solution for this problem.

0 REPLIES 0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors