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.
Hello,
I want to calculate strike for each employee .
Employee daily production target is 100.
I have 20 employees in my team, i want to calculate strike for each one( if Employee A worked 20 days in month and out of these two day he didn't do production as there target, then strick rate is =(Total number of working days -number of missed days)/total number of working days
How to calculate missed days here
To calculate the strike rate for each employee based on the number of missed days, you can use the following DAX formula in Power BI:
Strike Rate = (1 - DIVIDE(COUNTROWS(FILTER('Table', 'Table'[Missed Days] > 0)), COUNTROWS(FILTER('Table', 'Table'[Total Days] > 0))))
Here, 'Table' refers to the name of the table in your data model that contains the employee data.
Assuming that you have columns named 'Employee', 'Total Days', and 'Missed Days' in your table, the formula works as follows:
You can then use this calculated strike rate field in your Power BI visuals, such as a table or a card, to display the strike rate for each employee.
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 |
---|---|
103 | |
101 | |
76 | |
66 | |
60 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |