Forum Discussion

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
8 years ago
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]) ), ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    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. 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Again, tough to say without the data to replicate. But, if you have a relationship between your two tables based on Date. Then you will never have a match between them where date in one table matches -1 date from another table. Does that make sense?

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
8 years ago

Yes, thanks Greg_Deckler it makes sense, except that I thought the All() filter would remove that relationship. No?

May

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

    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. 

    • RobertSlattery's avatar
      RobertSlattery
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

      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.