Show only Null Values Expression

[#1]

I have some data with Null values to report on and unable to figure out the correct expression.

I want to see only data with NO implementation partner associated.

I'm able to see all data WITH an implementation with the following expression:

=count ({< Type = {'*Onboarding*'}, [Implementation Partner] = {'*'}>}[Success Plan: ID])

Simply adding '-=' for Implementation Partner does not produce the opposite result. For some reason this zero's out the results. Any clues, this seems like it should be easy?

[Anil_Babu_Samineni]

May be try this?

=count ({< Type = {'*Onboarding*'}, [Implementation Partner] = {' '}>}[Success Plan: ID])

[Anonymous · Accepted solution]

=count ({$<Type = {'*Onboarding*'}> -  <[Implementation Partner] = {'*'}> }[Success Plan: ID])

[#4]

Thanks but for some reason, Anil, this brings back all data, including those WITH Partners associated.

[Anonymous]

are you sure, you're using real null() values?

[Anil_Babu_Samineni]

What if you are getting when use like below

=count ({< [Implementation Partner] = {' '}>}[Success Plan: ID])

OR

=count ({< [Implementation Partner] = {'0'}>}[Success Plan: ID])

OR

=count ({< [Implementation Partner] = {'-'}>}[Success Plan: ID])

OR

=count ({< [Implementation Partner] = {"=Len([Implementation Partner])>0"}>}[Success Plan: ID])