Summarize in Power BI

[LCook]

I've tried multiple formulas but cannot get my data to summarize. Example of the data is:

Date	Location	Unit Type	Outbound Units
11/9	Miami	Small	500
11/9	Chicago	Large	625
11/9	Chicago	Small	754
11/7	Miami	Large	234
11/5	Los Angeles	Medium	567
11/5	Miami	Small	125
11/6	Chicago	Large	300
11/6	Los Angeles	Large	409
11/6	Los Angeles	Small	512

I want to summarize the data in a new table to total the units by date and location. The unit type can be ignored.

[LCook]

Thank you! This worked! I think I know where I was originally going wrong now. 

[ERD]

Hi @LCook , you want it as a visual or you need a virtual/physical table?

In case of a measure (just add it to the table visual with date and location columns):

units = SUM('Table'[Outbound Units])

A table:

ADDCOLUMNS (
    SUMMARIZE ( 'Table', 'Table'[Date], 'Table'[Location] ),
    "@units", CALCULATE ( SUM ( 'Table'[Outbound Units] ) )
)

[Dangar332 · Accepted solution]

Hi, @LCook 

Table 2 = 
ADDCOLUMNS(
       SUMMARIZE('Table (4)','Table (4)'[Date],'Table (4)'[Location]),
       "total unit",
        CALCULATE(SUM('Table (4)'[Outbound Units]))
          )

try below