topic Re: Labor Utilization Calculation in DAX Commands and Tips

Labor Utilization Calculation

Anonymous — Sat, 10 Dec 2022 18:14:43 GMT

I am new to DAX and need help with an equation that needs to count the number of occurrences when a date field shows "same date".

Date	EmployeID	CategoryID
11/1/2022	1	1
11/1/2022	2	1
11/1/2022	3	1
11/1/2022	4	2
11/1/2022	5	2
11/1/2022	6	2	0.882353
11/2/2022	7	1
11/2/2022	8	1
11/2/2022	9	1
11/2/2022	10	1
11/2/2022	11	1
11/2/2022	12	2
11/2/2022	13	2
11/2/2022	14	2	0.843137
11/3/2022	15	1
11/3/2022	16	1
11/3/2022	17	1
11/3/2022	18	1
11/3/2022	19	2
11/3/2022	20	2
11/3/2022	21	2
11/3/2022	22	2	0.862745

How do I count the number of Category ID entries within same date range, then create the calc of

(Total # Emps - Category Counts)/total # Emps

Re: Labor Utilization Calculation

FreemanZ — Sun, 11 Dec 2022 19:01:51 GMT

not so sure about the issue and your expected result. this might be helpful:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906

Re: Labor Utilization Calculation

v-yueyunzh-msft — Mon, 12 Dec 2022 02:03:13 GMT

Hi , Anonymous

According to your description, you want to " count the number of Category ID entries within same date range". Right?

But fo the "0.882353,0.843137,0.862745" , i can not kown how to calculate this value.

My test data is the same as yours.

Based on my understand , the "2022/11/1" for the count fo category is 2?

If this , you can click "New Column":

Column = var _rowdate = [Date] var _t =SELECTCOLUMNS( FILTER('Table','Table'[Date]=_rowdate) , "Category" , [CategoryID]) return COUNTROWS( DISTINCT(_t))

Then you can get the the number of Category ID entries within same date range.

If this does not meet your needs, can you provide us with your expected output and your detailed calculation logic?

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly