Trying to Create Headcount Measure for Employees over Time

Hi JonV ,

The question in your measure is about the filter part on your calculation.

When  you are refering to:

 Date[Date] >= Fact[HireDate] && Fact[EffectiveDate]

OR

 Date[Date] <= Fact[TerminationDate] && Fact[ExpirationDate]

This is not returning any value since you are searching for Hire data greate than the selected date (this is correct) but then you add AND (&&) Effective date it't not picking up what you need because of the way the relationships are setup.

Without any data is difficult to give you the correct answer, but if you look at the post you refer the MAX and MIN are used within a filter expression that is what I think is missing here.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.