Forum Discussion
Problem calculating production rate
Philippe,
My mistake, try the below. I just added Production[Date] to the SUMMARIZE function.
Production Rate (Measure) = VAR MinutesProduced = SUM ( Production[MinutesProduced] ) VAR MinutesOpen = SUMX ( SUMMARIZE ( Production, Production[EmployeeID], Production[Date], Production[Minutes opened] ), Production[Minutes opened] ) VAR Result = DIVIDE ( MinutesProduced, MinutesOpen ) RETURN ResultThis is what mine looks like now:
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Hi Philippe,
Try this for your production rate measure:
Production Rate (Measure) =
VAR MinutesProduced = SUM ( Production[MinutesProduced] )
VAR MinutesOpen =
SUMX (
SUMMARIZE ( Production, Production[EmployeeID], Production[Minutes opened] ),
Production[Minutes opened]
)
VAR Result =
DIVIDE (
MinutesProduced,
MinutesOpen
)
RETURN Result
Instead of adding the percentages together as you are currently doing (ie: dividing the minutes produced by the minutes opened for each employee, then summing), it adds up all the minutes produced and all the minutes opened for all the employees, before doing the division.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
Hi again Wilson_ ,
after checking the measure in the pbix file, it seems that it works partially.
The measure is working fine for each day, but it's not working for the total unfiltered and also not working if I select an employee.
It seems that the function that group the minutesopened for each employee doesn't take in consideration the day.
What i need to do is have one iteration of minutesopened per employee and per day (I don't know if it's understandable).
Thanks for your help.
Philippe.
Philippe,
My mistake, try the below. I just added Production[Date] to the SUMMARIZE function.
Production Rate (Measure) = VAR MinutesProduced = SUM ( Production[MinutesProduced] ) VAR MinutesOpen = SUMX ( SUMMARIZE ( Production, Production[EmployeeID], Production[Date], Production[Minutes opened] ), Production[Minutes opened] ) VAR Result = DIVIDE ( MinutesProduced, MinutesOpen ) RETURN ResultThis is what mine looks like now:
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)Thanks, it works perfectly now.
Have a nice day.
Philippe.
Awesome, thanks for letting me know. Happy to help, Philippe. 😄