Forum Discussion
Relationship direction problem
I found the problem:
The SUM function only calculates the brochure.creditvalue for each unique brochure.brochureid. If the same brochure.brochureid exists in a different brochureOrder for the same day the brochure.creditvalue is only added once. This is caused by the relationship between brochures and brochureOrderDetails (default = wrong direction of join).
I solved this by adding this measure to the brochureOrderDetail table:
Credits = sumx(NATURALINNERJOIN(BrochureOrderDetails;Brochures);Brochures[CreditValue])
Then that most likely means there is something wrong with your measure. Can you post the DAX for each of your two measures?
NrOfBrochures = COUNT(BrochureOrderDetails[BrochureId])
CreditValue = this is just a sum function of the field Brochure[CreditValue]
Is it possible this problem is caused by the fact that the Brochures[orderlineid] is the same for brochures with the same brochureId in an brochureOrder ?
I found the problem:
The SUM function only calculates the brochure.creditvalue for each unique brochure.brochureid. If the same brochure.brochureid exists in a different brochureOrder for the same day the brochure.creditvalue is only added once. This is caused by the relationship between brochures and brochureOrderDetails (default = wrong direction of join).
I solved this by adding this measure to the brochureOrderDetail table:
Credits = sumx(NATURALINNERJOIN(BrochureOrderDetails;Brochures);Brochures[CreditValue])