NOT ISBLANK not working in DAX expression

[saivina2920]

I am trying to form the DAX Expression for Pie Chart. But, the count is not coming properly.

below is my table.

Below is the expression.

Total_A = CALCULATE(COUNT('TEST DATA'[RECID]),FILTER('TEST DATA',(NOT ('TEST DATA'[COUNTRY-A] IN {"NOT APPLICABLE"} )

&& NOT ('TEST DATA'[COUNTRY-B] IN {"NOT APPLICABLE"} )

&& NOT ('TEST DATA'[COUNTRY-C] IN {"NOT APPLICABLE"} )

) && NOT ISBLANK ('TEST DATA'[CODE])))

RETURN Total_A

Here NOT ISBLANK is not filtering. 

what could be the problem..

The Result of the TOTAL IS : "3".  But,i am getting always 5....

How it is possible...?

[Doflamingo]

Hi,

I really don't understand the answers pointing to the blank function, my PowerBI doesn't recognize this crappy function and null (all lowercase!) works very well.....

You can simply compare the column with null....

Example : if [column A]<>null then .... else ....

Respect the case! because with  If, IF, Null, NULL : it doesn't work!

Doffy

[PC2790 · Accepted solution]

Try :

Total_A = CALCULATE(COUNT('TEST DATA'[RECID]),FILTER('TEST DATA',(NOT ('TEST DATA'[COUNTRY-A] IN {"NOT APPLICABLE"} )
&& NOT ('TEST DATA'[COUNTRY-B] IN {"NOT APPLICABLE"} )
&& NOT ('TEST DATA'[COUNTRY-C] IN {"NOT APPLICABLE"} )
) && 'TEST DATA'[CODE] <> Blank()))

[saivina2920]

what would be the condition if only blank instead of <> Blank()

&& 'TEST DATA'[CODE] <> Blank()

&& ISBLANK 'TEST DATA'[CODE]

Total_A = CALCULATE(COUNT('TEST DATA'[RECID]),FILTER('TEST DATA',(NOT ('TEST DATA'[COUNTRY-A] IN {"NOT APPLICABLE"} )
&& NOT ('TEST DATA'[COUNTRY-B] IN {"NOT APPLICABLE"} )
&& NOT ('TEST DATA'[COUNTRY-C] IN {"NOT APPLICABLE"} )
) && ISBLANK('TEST DATA'[CODE])))

Will the above work...?