8 Replies Latest reply: May 2, 2016 8:59 AM by Tal Sibony RSS

    Count if not null

    Tal Sibony

      Hi,

       

      how should I write the measure function if I want it to count 1 of the dimensions only if the value is not null?

      For example, currently the expression is: Count([demo column])

      but I don't want it to count the null rows..

       

      Thanks,

      Tal