Count Non-null Values
BI and PQ DATA TIPS AND TRICKS
{"Count", each Table.RowCount(_), Int64.Type}})
{"Count", each List.NonNullCount(_), Int64.Type}})
List.Count(List.RemoveNulls(Record.ToList(Record.RemoveFields(_,"Total Sales"))))
Table.RowCount(Table.SelectRows(_,(x)=>x[Total Sales]<>null)),
SOLUTION --> GroupBY Table count of non null values