I'm hoping there is a common fix for this since I'm sure others have run into this. But I have not found a solution online yet.
I am using above() in a chart to sum 4 trailing weeks into a single week value. But when I select a few weeks the last most weeks appear artificially low because there are no values 'above' them; they have been filtered out. If I manually exclude week from the selection like Weekending=, I then prevent the user from selecting these weeks (for this chart). How can I maintain the above() calculation when the dimension has been filtered?