Hi, I have calculated a measure called Total Overtime Hours ( for each employee) ( 0-10, 11-20, 21-30 etc. ) . I need to now club the number of people that fall under each overtime category.
How can i count the number of employees under each category of Total Overtime Hours measure.
Thanks for your help.
Shantanu
Hi Shantanu,
There's not enough information to help you.
1. Is this for a single period (day/week/month/year).
2. How is the measure written?
3. What level of granularity (day/week/month/year) are you wanting to perform the counts of people by category?
Please provide a mock up Excel or Power BI Desktop file with your sample data, your measure and desired output presented as you would have it in a PivotTable.
Once we can see your question in context of the data and desired output we will be able to help you further.
Thanks,
Mynda
