Employee Transfers

[Anonymous]

Hi,

I am trying to create a measure in DAX that counts how many active employees transfered from one department to another.

I have theses lookup tables and the data table with the relationships:

The EEChanges is a report from the HRMS that indicates who transfered from and to the location, business unit, comany and department ID. 

I have tried variations of the calculate and counta functions but I get this result which is not correct:

I have attempted to get help with another person in my company and he is not sure either.

Any help would be greatly appreciated!

Regards,

Mike

[Anonymous]

Hi @Anonymous 

There are too many tables and relationships in the screenshot you provided, so I have no way to give you the results. Can you provide me with your pbix file(remove sensitive info), your formula and the result you want to achieve ?

Best Regards,
Community Support Team _ Ailsa Tao