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 have a problem with my retention rate calculation in that it shows negative values for a time period from Sep - May. But the monthly retention rates are working fine .
I understand that we are hiring many staff for a role , but not sure why the measure is skewing up and showing negative values.
As in the screenshot below we can observe the Retention for the entire time period from Sep 20 - may 21 is -128%.
Below are the dax measures used for the Retention% calculation. It would be great if you can have a look at the measures and let me know if there is some error.
1. Active -SOP(Active start of the Period):
Solved! Go to Solution.
Hi Hasham,
That's true. But I have validated that the Active SOP and the number seems correct and the termination number is higher because as we hired more and more staff therefore termination has resulted in a higher number due to the new hired staff.
At this point I am looking at a measure which gives me retained staff which is a direct calculation and is not dependent on the measures ACTIVE SOP and Termination.
Would you be able to help me formulate a independent staff retained measure which gives staff who were active during the start of the period (Sep 20) and are still with the company for a time period selected.
Thanks in advance!!
Hi @Powereports !
The obvious problem is not just with [Retention %] but with all the measure at Total level.
So at Grand Total your [Active SOP] is 14 and your [Terminations] is 32, which yeilds -18 as [Staff Retained]. This messed up your retentiion % calculation as well.
Try fixing [Active SOP] measure, alternatively you can use [Active EOP] measure for calculating [Staff Retained] & [Retention %] calculation.
Regards,
Hasham
Hi Hasham,
That's true. But I have validated that the Active SOP and the number seems correct and the termination number is higher because as we hired more and more staff therefore termination has resulted in a higher number due to the new hired staff.
At this point I am looking at a measure which gives me retained staff which is a direct calculation and is not dependent on the measures ACTIVE SOP and Termination.
Would you be able to help me formulate a independent staff retained measure which gives staff who were active during the start of the period (Sep 20) and are still with the company for a time period selected.
Thanks in advance!!
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |