I actually came up with a solution to this problem, but I think there may be a simpler way you can point out to me. Here’s what I’m working with:

The goal is to make it so BeginYear and BeginValue always correspond to the Year slicer and TotalDeltaValue = [Value]-[BeginValue].

BeginYear was easy enough:

But I struggled with BeginValue because I thought this would do it:

But it returned the sum of all values from all the years:

*The problem is that I’m not understanding why this returns the sum of Value for all years when I’m explicitly filtering for FIRSTDATE.*

What I ended up doing to make it work:

Mission accomplished:

**BUT:**

- Can you explain the flaw in my logic for BeginValue1?
- Is there a more elegant solution?

Thank you.