Count Null value in set modifier in straight table

[Anonymous]

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

[sunny_talwar]

Can you add [Transcript Status Description] to this table and see what happens?

[Anonymous]

[sunny_talwar]

That is strange... are you sure you have not made any selections? Difficult to say what the issue might be because the expression should work in KPI and table.

[Anonymous]

I have gotten some progess

I think I know why its doing this.. I have a concat field (student).

[sunny_talwar]

add [Learner TID] as a dimension.... It seems you are adding these as fields may be

[Anonymous]

yup totally did the trick!

Thank you again!!