Forum Discussion
ViDax
3 years agoNew 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:
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