Forum Discussion
Calculating Percentage Complete with monthly requirement
Super UserHi tnevarez
I would like to help but I'm a little unclear about your requirements.
Can you show the following?
1) Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
3) Please explain how you would expect to get from step 1 to 2.
4) If possible, please show your past attempts at a solution.
I hope this helps.
I apologize for the delay in responding...I had to remove sensitive data and re-create a basic copy of my file.
I have attached a link to my desktop file for viewing. This includes 2023 data with employees and supervisors. Upon inspection, you will notice that the requirement is 2 observations per month. Some employees do not meet requirement (with either 0 or 1 observation) while others go above the requirement and complete more. In calculating % complete, this alters the result sometimes showing that certain employees or supervisors are >100% complete.
- When filtering by employee, the greatest % complete needs to be 100
- When filtering by supervisor, those that completed more than the required 2 per month, only need to have 2 calculated in the equation so that they are not making up for those that did not meet requirement. I wrote a measure to try and resolve that by only counting 2 when the total observation count >=2, however it counts a static 2 in the totals. This measure also will not work when selecting more that just one month in the date slicer (for example a supervisor wants to view his team's results on meeting requirement for more than one month at a time.
Please let me know if you need further information to help and thanks in advance!! (I have been stumped on this for months!)