power bi 度量值SUMX(FILTER和EARLIER结合

累计需求 = SUMX(FILTER(‘summary’,‘summary’[索引]<=EARLIER(summary[索引])&&‘summary’[RM_PN]=EARLIER(summary[RM_PN])),
‘summary’[计划量])

SUMX(FILTER
在’summary’表里，按条件筛选，对’summary’[计划量] 求和

EARLIER函数 理解为current 当前行
具体参考 https://www.jianshu.com/p/1ec7bcfa92cd

‘summary’[RM_PN]=EARLIER(summary[RM_PN] 按零件号求和