Forum Discussion
COUNTBLANK function issues
I have a COUNTBLANK function in my Power BI to show the columns where someone has forgotten to put in a number of details but it counts where there is an empty entry in the name column. For some reas...
Anonymous - I would use Clean and Trim operations in Power Query to get rid of any stray characters. You could also try:
Count Blanks = COUNTROWS(FILTER(ALL('Table'),ISBLANK([Column]) || [Column]="" || LEN([Column])<3))Also, why are you not flagging rows with missing data versus columns?
amitchandak Annoying that function still returns (Blank) meaning there is nothing to count, however, I can see there is a space in my data column still.
Greg_Deckler
Community Champion
Community ChampionAnonymous - I would use Clean and Trim operations in Power Query to get rid of any stray characters. You could also try:
Count Blanks =
COUNTROWS(FILTER(ALL('Table'),ISBLANK([Column]) || [Column]="" || LEN([Column])<3))
Also, why are you not flagging rows with missing data versus columns?