Text with Number Count in power query

[ukantkumar]

I need to count

1 st total row = 13

then

 Status using Unit

status is completed and unit not equal to 0 =6

like: 

Custom column=List.Count(
List.FindText( [Table name][status],"Completed" )  & List.Number([Table name][unit]<>0))

but it is not working?

[Zubair_Muhammad · Accepted solution]

@ukantkumar 

Try with

Table.RowCount(Table.SelectRows(TableName,each [Status] = "completed" and [unit]<>0))