Forum Discussion

ViDax's avatar
ViDax
New Member
3 years ago

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:

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:

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

No RepliesBe the first to reply