Forum Discussion
Solved
Previous Day Value
Why does this work... Order Value Prev Day = CALCULATE(
SUMX(orderLines, [Amount] * RELATED(Order_Types[Sign])),
FILTER(
orderLines,
[Date] = MAX('Dim Date'[Date])
),
...
Nope, ALL just removes all of the context filters but not the relationships. Let me see if there is a way to do that but I'm not sure.
Nope, ALL just removes all of the context filters but not the relationships. Let me see if there is a way to do that but I'm not sure.
Ok, in that case it now makes perfect sense. I've seen patterns where they say not to have any relationship between tables. Now I understand why.