Forum Discussion
Create a Measure: Cost Per Employee
I beleive you have your DIVIDE function flipped as I believe you want to divide the cost by the count of employees. Also, consider using the "alternative result" allowed in the DIVIDE syntax: https://docs.microsoft.com/en-us/dax/divide-function-dax
If you can post a sample of your data (using proxy data as we of course would not wish for you to disclose personal employee data) we would potentially be able to help you more.
If this helps please kudo.
If this solves your problem please accept it as a solution.
I beleive you have your DIVIDE function flipped as I believe you want to divide the cost by the count of employees. Also, consider using the "alternative result" allowed in the DIVIDE syntax: https://docs.microsoft.com/en-us/dax/divide-function-dax
If you can post a sample of your data (using proxy data as we of course would not wish for you to disclose personal employee data) we would potentially be able to help you more.
If this helps please kudo.
If this solves your problem please accept it as a solution.
Perfect thank you.