topic Re: Productivity/Capacity production in DAX Commands and Tips

Productivity/Capacity production

italobveloso — Tue, 21 Feb 2023 19:29:29 GMT

Hi everyone!

I'm trying to create a metric to check our productivity/Capacity.

I have a table with ID employee, Product Type, Created(Date), and Count.

The maximum capacity that each employee can do per day is 3
Product "D" count as 1 and product "E" as 0.5

Basically, I need to sum Column(Count) per each day to each employee and divide by 3 *100( percentage).

The same thing but for month, year, and total.

I really appreciate any tips or ideas!

Thanks!

amitchandak — Wed, 22 Feb 2023 04:04:55 GMT

italobveloso , Try a measure like

Averagex(Values(Table[Employee]), calculate(Sumx(Table, if(Table[Product] = D,1,.5) ) ) )

italobveloso — Wed, 22 Feb 2023 20:53:56 GMT

I think it worked 🙂
I used this measurement(you provided) and divide it by 3(maximum capacity per day for each employee).

Just two more questions

How do I do to show the days that Employee didn't produce anything?
How do I do to show the total(all production divided by total capacity)?