Using NOT ISBLANK as filter

[SJ25]

This should be fairly simple as I've done this before and it has worked great. I'm trying to count rows that are not blank and below is the syntax I'm using:

CALCULATE(COUNTROWS('TableName'),FILTER('TableName', NOT(ISBLANK('Tablename'[Sales Order]))))

But this gives me a count of all rows, why is this not working?? 

It gives me the right value when I use <> BLANK but what's wrong with the method above?

[camargos88 · Accepted solution]

Hi @SJ25 ,

Is it a text column ? If yes, have you tried to clean/trim it ?

Did I answer your question? Mark my post as a solution!
Ricardo

[SJ25]

@camargos88 That was it. It was a text column and should've converted to a number format. thanks for pointing out that silly mistake