Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to create a new measure that will calculate the healthcare "Cost Per Employee".
I'm trying to create this as a measure that I can include in several tables and graphs. This needs to calculate on a monthly basis since I will be plotting it that way. I have several slicers as well so it needs to be dynamic that way as well.
In the simplest form; the formula is: (# of Employees) divided by (Plan Paid):
My attempted solution was:
= DIVIDE(CALCULATE(DISTINCTCOUNT('Claim Data Pull'[Member ID]), FILTER('Claim Data Pull','Claim Data Pull'[Relation]="Employee")), SUM('Claim Data Pull'[Paid]))
Can you assist me in resolving the issue? Currently my results are 0:
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |