Categorizing values

[Anonymous]

Spoiler

Spoiler

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. 

[Anonymous]

Your video is mentioning how to count employees like a pivot table but I need a way to have all employee names in a table if I select for example <35 in a slicer , button , or any other way. 

 How can I insert a dummy excel file for you to see

thanks fo your help

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak 

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

[Anonymous]

@amitchandak 

[amitchandak]

@Anonymous , you have to create bucket around measure [Sum Paid Hours] using independent table

refer if my video can help

https://youtu.be/CuczXPj0N-k