Power query help for adding conditional count column

Hi PSB!

You can do the column in two steps. First you want to do the distinct count group by brand, then you can expand the result.

In the advanced editor, it should look like this:

 #"Grouped Rows" = Table.Group(#"Changed Type", {"Brand"}, {{"Count", each Table.RowCount(Table.Distinct(_)), Int64.Type}, {"All", each _, type table [Brand=nullable text, Type=nullable text, Store=nullable text]}}),
#"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"Brand"}),
#"Expanded All" = Table.ExpandTableColumn(#"Removed Columns", "All", {"Brand", "Type", "Store"}, {"Brand", "Type", "Store"})"All.Type", "All.Store"})

Cheers!

PSB , DAX, You can try a new rank column

Column = RANKX(Data,[Brand] &[Store],,ASC,Dense)