topic Re: Categorizing values in DAX Commands and Tips

Categorizing values

Anonymous — Fri, 30 Apr 2021 16:26:04 GMT

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.

Re: Categorizing values

amitchandak — Fri, 30 Apr 2021 16:51:36 GMT

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

Re: Categorizing values

Anonymous — Fri, 30 Apr 2021 17:38:40 GMT

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

Re: Categorizing values

Anonymous — Fri, 30 Apr 2021 17:59:59 GMT

amitchandak

Re: Categorizing values

amitchandak — Sat, 01 May 2021 05:12:05 GMT

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

Re: Categorizing values

Anonymous — Sun, 02 May 2021 01:41:48 GMT

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