Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
5 years ago

BLANK DATA

Hello everyone, I have been presented with a very particular case. contextualize a little: I have a column called Adults, when I start by observing that this column is formatted as "Text" so I d...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Syndicate_Admin ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Try like

countrows(Filter(Table, Table [adult]> 0))

 

or

countrows(Filter(Table, isblank(Table [adult]) || Table [adult]<> 0))