Forum Discussion
RobertSlattery
Responsive Resident
Responsive ResidentPrevious 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.
RobertSlatteryResponsive Resident
Responsive ResidentYes, thanks Greg_Deckler it makes sense, except that I thought the All() filter would remove that relationship. No?
May
Greg_Deckler
Community Champion
Community ChampionNope, 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.
- RobertSlattery
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.