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??