Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
@Anonymous Perhaps:
Number of Cells =
VAR __NumColumns = 3
RETURN
COUNTROWS('Table')*__NumColumns
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
101 | |
73 | |
70 | |
47 |
User | Count |
---|---|
145 | |
106 | |
105 | |
90 | |
65 |