Appendix. Dax식 Calculate

1. Data Analysis Expressions (DAX)

1.1 CALCULATE - Filter Functions

CALCULATE(<expression>[, <filter1> [, <filter2> [, ..]]])
# <expression>: sum, average, min, max, count, distinctcount 

e.g.

Total sales on the last selected date =
CALCULATE (
	SUM ( Sales[Sales Amount] ),
    'Sales'[OrderDateKey] = MAX ( Sales'[OrderDateKey])

1) 홈 리본에서 새 측정값 선택
2) 아래와 같이 식 입력

*다음 줄로 내릴려면 Shift+Enter 클릭

-- 재직 인원
Working HC =
			CALCULATE(DISTINCTCOUNT(HR[EmployeeNumber]),
            						HR[Attrition] = "No")

-- 퇴직 인원
Retired HC =
			CALCULATE(DISTINCTCOUNT(HR[EmployeeNumber]),
            						HR[Attrition] = "Yes")

3) Enter 클릭하여 완료