Sorry for the weird title, I really can't find a way to sum up my question.
Here's the deal:
I have these tables:
Table A - Table B - Table C - Table D
Here's how they relate:
Table A to B one to many. (one way)
Table B to C many to one. (Both ways)
Table C to D one to many. (one way).
I have a measure that just sums a column of the D table.
Now, when I make a matrix and I add a column from Table A and the measure, something weird happens. Rows from table A that don't relate to any rows of table B show the sum of all the rows of table D that don't relate to any rows of table C.
So, when everything relates OK, the measure works OK, but I really don't know why DAX is doing this when they don't, I would just expect a blank result.
I can fix this by filtering the sum, but I just want to understand what is happening.
Sorry if I didn't explain my situation correctly, and thank you very much for any answers
