Count column calculated by group

[Anonymous]

Hello everyone,

I have a column with four groups and I wanted to create another column to have a count indicator in each group of this column.

How can I do that?

My dataset

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vRTMDayVNJRUorVIZFnYmQA5zkpGBmbEMkzNjCgKQ/VZZTzYgE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Group = _t, #"Cont by Group" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Group", type text}, {"Cont by Group", type text}})
in
#"Changed Type"

[Ashish_Mathur]

Hi,

Refer to the solution offered by ImkeF here - Solved: Custom column Index or Ranking by other column - Microsoft Power BI Community.

Hope this helps.

[AlB · Accepted solution]

Hi @Anonymous 

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vRTMDayVIrVIY5pYmQAYTopGBmb4GcaGxhQi4lkMRnMWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Group = _t]),
    #"Grouped Rows" = Table.Group(Source, {"Group"}, {{"Cont by Group", each List.Numbers(1,Table.RowCount(_))}}),
    #"Expanded Cont by Group" = Table.ExpandListColumn(#"Grouped Rows", "Cont by Group")
in
    #"Expanded Cont by Group"

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers