Forum Discussion
Categorizing values
Hi everyone,
Need some help over here 😊
I have for an employee how many daily worked hours. And this for everyday for a week.
- Created mesures to see how many employees worked 35 or 37.5 or <40 etc. hours per week.
CALCULATE(
COUNTROWS(
FILTER(ADDCOLUMNS(SUMMARIZE(Hours,Hours[Name]),"SumHours",CALCULATE(SUM(Hours[Hours]))),[Sum Paid Hours]=35)
- Created mesures to see how many hours in total for employees that worked 35 or 37.5 or <40 etc. hours per week.
CALCULATE(
SUM(Hours[Hours]),
FILTER(ADDCOLUMNS(
SUMMARIZE(Hours,Hours[Name]),"SumHours",CALCULATE(SUM(Hours[Hours]))),[Sum Paid Hours]=35)
I'm looking for a way to show in a table or matrix all employee per group ( 35 hours per week, 37.5 hours per week,etc.)
I've tried to create to column but I'm lost.
5 Replies
Anonymous , you have to create bucket around measure [Sum Paid Hours] using independent table
refer if my video can help
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Here is an excel fila of a sample.
Hope it can helps .
Thank you very much
https://drive.google.com/drive/folders/1zC77R6nP6OFu7i73xDUI1Bm98--x6BJ9?usp=sharing
