how to compute measure of another dimension table

[Anonymous]

I have a data model like the following:

Dimension Employee   1-*   Fact Sales   *-1   Dimension Date

Dimension Employee:

Emp Key    Emp ID   ...

Dimension Date:

Date Key   Date   ...

Fact Sales:

Emp Key   Date Key   Sale Amount

I want to get a head count of all employees that were valid for some date range (as determined by a selection of 'Dimension Date'[Date]).  This is very similar to the solution in the following post:

Solved: Creating a measure based on a dimension table - Microsoft Power BI Community

So, I have attempted:

Head Count =
COUNTROWS(
    SUMMARIZE(
        'Fact Sales'
        ,'Dimension Employee'[Emp ID]
    )
)

However, this isn't returning the correct value.  It returns the same value for every selection of 'Dimension Date'[Date].  How can I resolve this?  Note: Turning on bidirectional crossfiltering or replicating [Emp ID] into the fact table are not acceptable solutions.

[amitchandak · Accepted solution]

@Anonymous , does Dimension Employee has a hire and termination date? because then solution is different like

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

if not

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.