I have a requirement where I need to use context filters, but I also need to create some calculations using FIXED LOD expressions.
How can I achieve this so that the FIXED LOD calculations are not affected by the context filters?
3 answers
In Tableau, context filters do affect FIXED LOD expressions by default - FIXED LODs are calculated after context filters but before dimension filters.
If possible, don’t add the filter to context. FIXED LODs ignore regular dimension filters - so if the filter is not in context, it won’t affect your FIXED expression.
