Forum Discussion

saivina2920's avatar
saivina2920
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

NOT ISBLANK not working in DAX expression

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...?
 
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    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()))

3 Replies

  • PC2790's avatar
    PC2790
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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's avatar
      saivina2920
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

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

  • Doflamingo's avatar
    Doflamingo
    New Member
    2 years ago

    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