3 Replies Latest reply on Nov 6, 2018 6:50 AM by Deepak Rai

    An LOD that changes to specific dimension (quick) filters and not for other dimension (quick) filters

    Sagar Kavitake

      Hi All,

       

      I have a requirement where in I want my LOD Measure to change if a dim1 quick filter changes and it should not respond when dim2 quick filter changes (it should stay with the same value as after applying the dim1 filter).
      So I tried few combinations of FIXED nested under INCLUDE and some others with EXCLUDE as well.
      But nothing seems to be working for this requirement.

       

      So this is how it should work:

       

      Region (Dim1 Quick Filter)
      Sub-Category (Dim2 Quick Filter)Output
      Rows
      AllAll

      5009

      5009

      5009

      CentralAll

      1175

      1175

      1175

      CentralChairs1175
      AllChairs5009