0 Replies Latest reply: Oct 28, 2017 1:24 PM by Josh Martyne RSS

    Hide null values in a measure

    Josh Martyne

      Hi,

       

      I am comparing two dates, one of which is calculated using a variable which is assigned from a user input in the front end.

       

      This is displaying a table of initiatives, and I wish to hide rows which do not have their initiative name displayed (as the dates haven't fulfilled the requirements)

       

      The calculation is below:

       

      if(max({ $<[Timeline Content]={"CLD"}> } [Timeline Start Date]) <> max( { <[Timeline Content] = {'.'}> * <[Timeline Start Date] = {'<=$(=$(vTest1))'} > } [Timeline Start Date] ),[Initiative Name])

       

      This is a measure (due to operators such as MAX), if it was a dimension I could 'hide null values' for this column. Any suggestions as to how I could get rid of them and only display rows which satisfy the above algorithm?

       

      Thanks