Forum Discussion

LCook's avatar
LCook
Frequent Visitor
2 years ago
Solved

Summarize in Power BI

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 1...
Need Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    Hi, LCook 

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


    try below

     

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
2 years ago

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] ) )
)