Forum Discussion
grouping data for custom category
Hi Truelearner ，
You could try below measure and refer to my sample for details.
Measure 2 = COUNTX(SUMMARIZE('Table (2)','Table (2)'[Emp],'Table (2)'[Date],'Table (2)'[status]),'Table (2)'[status])+0Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Truelearner ,
You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The logic you provided will for the sample data but the real data will have multiple days with same hours in those scenarios it will fails ,please check the below data where the logic provided will break ,
bascially i added two rows for employee 1 for for may 17 and the total working hours is same as working hours on 16th may and when i added you logic its failing . Kindly check
EmpclientDatehoursHourrs per dayColumn
| 1 | A | Friday, May 15, 2020 | 1 | 3.5 | below 7 |
| 1 | B | Friday, May 15, 2020 | 1.5 | 3.5 | below 7 |
| 1 | C | Friday, May 15, 2020 | 1 | 3.5 | below 7 |
| 1 | D | Saturday, May 16, 2020 | 4 | 10 | above 9 |
| 1 | E | Saturday, May 16, 2020 | 6 | 10 | above 9 |
| 2 | A | Friday, May 15, 2020 | 6 | 11 | above 9 |
| 2 | B | Friday, May 15, 2020 | 2 | 11 | above 9 |
| 2 | C | Friday, May 15, 2020 | 3 | 11 | above 9 |
| 2 | D | Saturday, May 16, 2020 | 1 | 9 | below 9 |
| 2 | E | Saturday, May 16, 2020 | 8 | 9 | below 9 |
| 1 | D | Sunday, May 17, 2020 | 4 | 10 | above 9 |
| 1 | E | Sunday, May 17, 2020 | 6 | 10 | above 9 |
Hi Truelearner ，
You could try below measure and refer to my sample for details.
Measure 2 = COUNTX(SUMMARIZE('Table (2)','Table (2)'[Emp],'Table (2)'[Date],'Table (2)'[status]),'Table (2)'[status])+0Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.