[Power BI] DAX - SUMMARIZE

 

 

SUMMARIZE

Returns a summary table for the requested totals over a set of groups.

 

 

Syntax

SUMMARIZE (<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, <name>, <expression>]…)

 

 

Example

SUMMARIZE(ResellerSales_USD  
      , DateTime[CalendarYear]  
      , ProductCategory[ProductCategoryName]  
      , "Sales Amount (USD)", SUM(ResellerSales_USD[SalesAmount_USD])  
      , "Discount Amount (USD)", SUM(ResellerSales_USD[DiscountAmount])  
      )

 

 

SUMM_TABLE 이라는 요약 테이블 만들기
TABLE에서 YEAR, PRODUCT, START, END 그룹화하고 갯수열 CNT를 추가한 테이블을 SUMMARIZECOLUMNS로 만듬
-> SUMMARIZECOLUMNS(TABLE[YEAR], TABLE[PRODUCT], TABLE[START], TABLE[END], "CNT", COUNT(TABLE[START])

해당 테이블에서 CNT가 1 이상인 행 들만 추출하고 싶음

SUMM_TABLE = SUMMARIZE(
FILTER(SUMMARIZECOLUMNS(TABLE[YEAR], TABLE[PRODUCT], TABLE[START], TABLE[END], "CNT", COUNT(TABLE[START])), [CNT] > 1),
[Year], [PRODUCT], [START], [END], [CNT]
)

 

 

 

 

 

docs.microsoft.com/ko-kr/dax/summarize-function-dax

SUMMARIZE 함수(DAX) - DAX