Hi all,

In my Employees dimension I have Employee Member
Properties "Hire Date" and "Term Date". I also have a
Headcount Measure which is set to show "1" if the
Employee received a paycheck during the month, and it
shows a "0" if the employee didn't receive a paycheck
during the month. Some Employees receive a paycheck, and
in the middle of the month thay are gone, whom I don't
want showing up in the Headcount measure as a "1"

Here is what I need to express in simple terms.

IF
Employee Member Property "Term Date" <= CurrentDate
then Measure.Headcount = 0
else 1

I tried something like this but I don't know what is
wrong with it:

IIF ([Employees].[Employee].Currentmember.Properties
("Term Date") <= CDATE(),0,1)

Note: "Term Date" is NULL if employee is still with the
company

Thanks in advance,

Dan