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:
- Can you explain the flaw in my logic for BeginValue1?
- Is there a more elegant solution?