2 Replies Latest reply on Feb 10, 2019 5:56 AM by Diego Parker

    Context filters

    Vandana Sharma

      Can context filters be used in place of LODs/fixed in calculations?

        • 1. Re: Context filters
          Jim Dehner

          Context filters can be used in conjunction with LOD expressions - but will affect the outcome

          Try it out with a simple worksheet using Fixed - Exclude or Include with and without context filter

          See how the filter affects the outcome ans you filter the dimensions



          1 of 1 people found this helpful
          • 2. Re: Context filters
            Diego Parker

            Hi Vandana,


            When using context filters and LODs I believe is very important to consider the order of operations.



            The context filter will always go before the LODs but a FIXED LOD can work as a context filter too, whilst an INCLUDE or EXCLUDE won't. You can use LODs and Context filters together but the application of the context may change the value of the LOD.


            If you have any further questions please do not hesitate on asking. If this was helpful or answers your question, please mark it as helpful/correct so other users can refer to it. Thanks!




            1 of 1 people found this helpful