15 Replies Latest reply: Dec 8, 2016 2:55 PM by Michael Goldshteyn RSS

    Count Null value in set modifier in straight table

    Michael Goldshteyn

      Greetings community,

       

       

      I am working on getting a table to show the students that are incompleted on the bases of:

      Count(DISTINCT {$< [Transcript Status Description] = {'Confirmed', 'In-Progress'}>} [Learner TID])

       

      Currently that is in my measure column.

       

      I am having a hard time getting this set modifier to count null values in the same column  [Transcript Status Description].

       

      I have attempted to create an if statement into a variable, but it doesn't seem to play nicely with the table as it does with my KPI

       

      any suggestions??