Released and Joined Employees count

Hi, Powerful 

You can try the following methods.

Measure:

Count1 = 
CALCULATE (
    COUNT ( 'Table'[Emp ID] ),
    FILTER (
        ALL ( 'Table' ),
        [Emp ID] = SELECTEDVALUE ( 'Table'[Emp ID] )
            && [Data Dump Date] <= SELECTEDVALUE ( 'Table'[Data Dump Date] )
    )
)

Count2 = 
CALCULATE (
    COUNT ( 'Table'[Emp ID] ),
    FILTER (
        ALL ( 'Table' ),
        [Emp ID] = SELECTEDVALUE ( 'Table'[Emp ID] )
            && [Data Dump Date] >= SELECTEDVALUE ( 'Table'[Data Dump Date] )
    )
)

Joined = 
CALCULATE (
    COUNT ( 'Table'[Emp ID] ),
    FILTER (
        ALL ( 'Table' ),
        [Data Dump Date] = MAX ( 'Table'[Data Dump Date] )
            && [Count1] = 1
    )
)

Released = 
CALCULATE (
    COUNT ( 'Table'[Emp ID] ),
    FILTER (
        ALL ( 'Table' ),
        [Data Dump Date] = MIN ( 'Table'[Data Dump Date] )
            && [Count2] = 1
    )
)

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.