Hi Shraddha, you can use LOD calculations to avoid filters in some cases, but the EXCLUDE keyword won't work here because the filter's at the wrong level. See here: Filters and Level of Detail Expressions
Can you convert that to use FIXED instead?
I have tried using FIXED too, it still doesn't work.
I have used a similar application earlier and it has worked then.
I don't understand why it doesn't work now.
@David - Where should my filter be instead?
Can you share a packaged workbook of the similar application that worked earlier? I don't think you can use EXCLUDE or INCLUDE to affect filters.
I'm sorry for the confusion, the earlier application worked with FIXED. Currently, FIXED is working for all other filters except date filter.
The way I see I think it is working is, when I use the date filter it limits the dataset to those records irrespective of whether I use INCLUDE, EXCLUDE or FIXED.
It works properly for all other filters though.
Do you know how I could resolve that?