Hi Kofi, give this a try.
I created a calculation called "Years Missed - Selected". This should return a single number which is the number of years selected in your Quick Filter. For this to work, you need to add your regular "Year Missed" filter to Context.
Now, we can simply compare The number of years selected in the filter to the number of years associated with each Attribute:
To get the number of years per attribute, we can simply do COUNTD(YEAR). To compare the two numbers we can create a True|False flag with the calculation [Years Missed by Record] = [Years Missed - Selected].
Then we filter the view by setting the True|False filter to True.
I hope this helps.
Filter For All Missing.twbx 28.8 KB
It worked. Thanks so much Jennifer.