1 Reply Latest reply on Jan 4, 2017 4:35 AM by Dhruv Gupta

    rows display

    wiem bekir

      Hello Guys,

      I have a table as bellow :

      service name   my measure

      a filtr on service name (only display the service names that start with IN)

       

      some months, the database does not contain data on service that strat with IN

       

      I would like to have 0 as  as the value of my measure if there's no rows in my database with service name start with 'In'

        • 1. Re: rows display
          Dhruv Gupta

          Hi Bekir,

           

          You can exclude the filter values(which does not start with IN) using filter wizard. create a calculated field as below:

           

          Calculated Field:

           

          If Left([service name],2)<>'IN' then 0

          Else [my measure]

          End

           

          and use this field in your visualization instead of [my measure].

           

          Hope this helps.

           

          Thanks,

          Dhruv Gupta

          1 of 1 people found this helpful