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,
I want to count the number of rows with multiple OR conditions in power query editor.
for example I want to count rows based on the below conditions
11: On Time
30: Impact
30: Expedite
60: Item
Solved! Go to Solution.
You can do the following in PBI:
Use this option to filter this column.
Group count of filtered columns
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLPUwjJzE1VitWJVjIC8j1zCxKTS8BcYyDXtaIgNSWzBCJvApIvSc0Fc0yBnNK87Lz88jww3wxVszm6Zgs0yyxR1RsaoJlnaIimwAjdRENjNCMNTTCUmKIrMUMXMEezxgLDDEv0YDJAV2JkiOZ4IyNkgVgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Status = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Status", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Status] <> "unknown")),
#"Grouped Rows" = Table.Group(#"Filtered Rows", {"Status"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
#"Grouped Rows"
You can do the following in PBI:
Use this option to filter this column.
Group count of filtered columns
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLPUwjJzE1VitWJVjIC8j1zCxKTS8BcYyDXtaIgNSWzBCJvApIvSc0Fc0yBnNK87Lz88jww3wxVszm6Zgs0yyxR1RsaoJlnaIimwAjdRENjNCMNTTCUmKIrMUMXMEezxgLDDEv0YDJAV2JkiOZ4IyNkgVgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Status = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Status", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Status] <> "unknown")),
#"Grouped Rows" = Table.Group(#"Filtered Rows", {"Status"}, {{"Count", each Table.RowCount(_), Int64.Type}})
in
#"Grouped Rows"
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |