New calculated table in DAX order by the count

Question

I am using SSAS Tabluar models and I am trying to create a calculated table based on the count of each subcategory.

ColumnA     ColumnB
SPN100      new
SPN100      old
SPN100      new
SPN200      new
SPN200      old

and I am trying to create a new table based on counts of ColumnB

Column A    Counts 
SPN100       3
SPN200       2

Answer 1

You can use SUMMARIZE or SUMMARIZECOLUMNS.

Summary = SUMMARIZE(Table, Table1[ColumnA], "Counts", COUNT(Table1[ColumnB]))

Summary = SUMMARIZECOLUMNS(Table1[ColumnA], "Counts", COUNT(Table1[ColumnB]))