1 of 1 people found this helpful
You should be able to pull YEAR off filters. Your calcs already do the job of gathering what you need to display.
You only seem to get one line if you select 2016 (in the parameter, with the YEAR filter off the sheet) because there is no [Straight Allocation] data in 2016, and the lines for Prior and Current are identical. (So the current configuration has Prior at the top of the Measure values list, and therefore it overlays Current and "hides" it. Take YEAR off the filter shelf, select 2016 in the parameter, and then just drag Prior and Current to change the order in the "Measure Values" list. You'll see what I mean. You can also see that they're identical in the "Table" sheet.)
So silly of me...I got the year filter in the filter shelf in error i believe and never look at it so taught it was not working as desired.
But thanks for the second eye on it and helping me.