Forum Discussion
Solved
Using NOT ISBLANK as filter
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?
It gives me the right value when I use <> BLANK but what's wrong with the method above?
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
2 Replies
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!
Ricardocamargos88 That was it. It was a text column and should've converted to a number format. thanks for pointing out that silly mistake