Forum Discussion

SJ25's avatar
SJ25
Resolver I
6 years ago
Solved

Using NOT ISBLANK as a filter

This should be quite simple, as I've done this before and it has worked very well. I'm trying to count rows that aren't blank and then there's the syntax I'm using: CALCULATE(COUNTROWS('TableNam...
  • amitchandak's avatar
    amitchandak
    6 years ago

    SJ25 ,

    Check if you column has some space trim those

    and then try CALCULATE(COUNTROWS('TableName'),FILTER('TableName', NOT(ISBLANK('Tablename'[Sales Order]) && 'Tablename'[Sales Order] <> "" )))))

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI SJ25,

Please check your table records to confirm if your field type changes or new values existed in your records. (empty, null, blank, "" or specific characters)
In addition, I think it will help if you share some dummy data to test.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng