In you case, I think combining LOD and IF Statement plus context filter will help.
When you add other filters, all the filter needs to be "Context" to make LOD calc work after filtering.
Thank you. That solution works for the specific instance I provided. I was hoping to be able to use it in a few other scenarios in which the calculation breaks down however. Specifically i would like to also show this calculation for 2016 vs. 2015 like we were able to do successfully for 2017 vs. 2016. Is it possible to enable that? When i drag the % change calculation to a separate column and separate out by year it appears to duplicated the % for both 16 & 17:
Additionally I would like for the calculation to not be impacted by selecting 2015 an additional data point in the filter
With my current approach, you can not get the delta of "2015 vs 2016" and "2016 vs 2017" at the same time.
If you are talking about the issue of only doubled Bar graph, to fix issue is just change the type of stack.
Bar chart's default setting is always "Stack ON" and Line chart's default setting is always "Stack OFF".
2015 and 2016's data is 100% over-wrapped and drag and drop to change the sort order on color shelf will bring different color.
Let me know you are asking different question.