[Power BI] DAX - CALCULATE

 

 

 

<예>

Sales 테이블 측정값 : 파란색으로 된 제품만 Sales Amount 합계 계산

Blue Revenue =
CALCULATE(
    SUM(Sales[Sales Amount]),
    'Product'[Color] = "Blue"
)

 

 

PreC =

var CurrentIndex = 'Table'[인덱스]

var CurrentName = 'Table'[Name]

return CALCULATE(SUM('Table'[C]),FILTER(ALL('Table'),'Table'[인덱스]= CurrentIndex - 1), 'Table'[Name] = CurrentName )

 

 

 

 

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

CALCULATE 함수(DAX) - DAX