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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.