HOW CAN I COUNT ALL THE "CELLS" IN A TABLE?

[Anonymous]

Hi all,

can you help me with this issu? 

i want to measure the totla number of "cells" in a table.

this example shows what i want. i have  table with three columns and three rows. the total cells with info es 9.

is thare any formula to do it?

Thanks

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

You can add a custom column as below in Power Query Editor to get it, please find the details in the attachment.

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlTSUTIEYkelWJ1opSQgywiIncC8ZCDLGIidlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"TITLE 1" = _t, #"TITLE 2" = _t, #"TITLE 3" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"TITLE 1", type text}, {"TITLE 2", Int64.Type}, {"TITLE 3", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Count of cells", each Table.RowCount(Source) *Table.ColumnCount(Source))
in
#"Added Custom"

Best Regards

[Greg_Deckler]

@Anonymous Perhaps:

Number of Cells = 
  VAR __NumColumns = 3
RETURN
  COUNTROWS('Table')*__NumColumns