11 Replies Latest reply on Jun 20, 2018 10:27 AM by Gerardo Varela

    Measure with a specific dimension value that ignores filters

    tarang.patel.3

      Hi,

       

      I am trying to get a measure with a specific dimension value that ignores the current filters. For example I want "1.57" in the network value column to appear for every Type. I'm using....

       

      [Network Value]

      if([Type] = 'network') then [Value]

      ELSE

      null

      END

       

      but I obviously need to be adding something. If we were to filter for Customer ZZZ instead of AAA than 5.6 should appear under Network Value for all Types. In summary I want the Network Type value of 1.57 to appear for all Network Values.