SUMMARIZE是新建一张表，语法：
SUMMARIZE(TABLE, GROUP BY COLUMN1, ..., GROUP BY COLUMNX, "NEW COLUMN 1", MEASURE 1, ......, "NEW COLUMN X", MEASUREX)
参数TABLE是需要分组的表
参数GROUP BY COLUMN1...X是需要分组的列
参数“NEW COLUMN1”, MEASURE1是派生的列名和度量值
使用SUMMARIZE新建一张表：
SUMMARIZE = SUMMARIZE(Sheet1, Sheet1[CATEGORY], Sheet1[PRODUCT], "AMT", [AMT], "MEASURE A", [MeasureA]) 新生成的表：
新生成的表的数据：
SUMMARIZE可以配合CALCULATE使用：
新建度量值：
SUMMARIZE A = CALCULATE( SUMX(SUMMARIZE(Sheet1, Sheet1[CATEGORY], "AMT", [AMT] * 2), MAX([AMT])))
标签：GROUP,Sheet1,NEW,SUMMARIZE,COLUMN1,AMT From： https://www.cnblogs.com/pandaking9537/p/17293194.html