DAX count wrongly with a slicer

[Nicolachan0416]

I am trying to calculate the headcount from a worksheet named - Master_Active2 and the slicer is applied the time period from a worksheet named - Master_In_Out.

As a result, i cannot find the correct headcount from the below formula: 

Could you help to let me know what would be the reason behind? Thanks.

[Anonymous]

Hi @Nicolachan0416 ,

Whether the advice given by bhanu_gautam  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please 

provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Neeko Tang

[bhanu_gautam · Accepted solution]

@Nicolachan0416 , Try using

Headcount =
CALCULATE(
COUNT(Master_Active2[Subsidiary Employee ID]),
USERELATIONSHIP(Master_Active2[Period_Month], Master_In_Out[Period_Month]),
FILTER(
Master_In_Out,
Master_In_Out[Period_Year] = SELECTEDVALUE(Master_In_Out[Period_Year])
)
)