3 Replies Latest reply on Jul 1, 2018 2:03 PM by Deepak Rai

    How to filter for all elements of a dimension containing a certain string

    Kasper Silverforsen

      Hi,
      Sorry for not giving you a workbook, I am unfortunately not allowed to do that.
      I have a dimension called "Release" which contains around 30 different names. Some of these names have been tagged with "(Latest)".
      The user is supposed to have the choice to filter for all releases or the latest releases through a paramter with options "All" and "Latest"

       

      I have tried a calculated field like this

       

      Name: Release Filter

       

       

      CASE [Release Type]

          WHEN "Latest" THEN

          IF Contains([Release], "(Latest)") THEN [Release] END

          WHEN "All" THEN

          [Release]

      END


      This works fine, but when I choose "Show Filter" for "Release Filter" and choose "Latest" then there is also a Null value which consists of all the releases not tagged with "Latest". How can I find the release names tagged with "Latest" and not have the Null value?

       

      BRs,
      K