Productivity/Capacity production

[italobveloso]

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]

@italobveloso , Try a measure like

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

[italobveloso]

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)?