sum the number type column when summarize

[Anonymous]

I want to summarize the below table with three columns Region, Territory and Value.

The Result table expected is as below

But when i say 

SUMMARIZE(Table1, Table1[Region], Table1[Territory],  Table1[Value]) it removes the duplicate of Region("North") and Territory("B") and shows Value(15). The expected value is to add the value and result 30.

Can anyone help on this. Thanks in advance.

[amitchandak · Accepted solution]

Try

SUMMARIZE(Table1, Table1[Region], Table1[Territory],"Value", sum( Table1[Value]))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin