Is there a way to summarize two columns and add a count aggregate column as third

[user35131]

I tried something like this 

 Sumamry Table = SUMMARIZE(Table,Table[race],Table[Borough],"Count",GROUPBY(Table,Table[race],Table[Borough]))

The third column count i would like to do sum or aggregate.

[littlemojopuppy · Accepted solution]

Hi @user35131 

Try this...

Sumamry Table = 
GROUPBY(
	Table,
	Table,Table[race],
	Table[Borough],
	"ItemCount",
	COUNTX(
		CURRENTGROUP(),
		[whatever you're counting]
	)
)

This will group by and then count something (not sure of field name).  If you want to SUM() then change COUNTX() to SUMX() and substitute the appropriate field after CURRENTGROUP().

Hope this helps!

[littlemojopuppy]

Note: this will produce a summary table.  What @amitchandak suggested will produce a numeric value