How to count cells that are 1) blank, 2) empty, 3) only include one or more empty chars like SPACE?

[UsePowerBI]

Hello

How to count cells that are 1) blank or 2) empty or 3) only include one or more empty chars like SPACE and TAB?

Thanks!

[amitchandak · Accepted solution]

@UsePowerBI , remove the empty space using trim or text.trim in M

Countrows(filter(Table,isblank(table[column])))

calculate(Countrows(table),filter(Table,isblank(table[column])))