Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Employee Transfers

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

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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