Forum Discussion
Problem calculating production rate
- 2 years ago
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?)
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 Result
This 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.
- Wilson_2 years agoMemorable Member
Awesome, thanks for letting me know. Happy to help, Philippe. 😄