Forum Discussion
Anonymous
2 years agoNot applicable
Problem calculating production rate
Hello everybody, I have a problem with a dashboard I'm working on. The data model is like that : There are four dim tables (on top) and 3 fact tables above. In the table "Rendement co...
- 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?)
Anonymous
2 years agoNot applicable
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. 😄