Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • Wilson_'s avatar
    Wilson_
    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 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?)

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for your solution Wilson_ , it seems to work perfectly.

 

I have a question for my understanding. In my MinutesOpen column, i have the value of a workday, but a row just represent an action during this workday. How the measures doesn't add all the minutesopen (if it was the case, the result would be totally false.

 

Thanks again for your help and have a nice day.

Wilson_'s avatar
Wilson_
Memorable Member
2 years ago

Philippe,

 

The minutes open is not duplicated in my measure because the SUMMARIZE function I am using groups by the columns in the parameters (in this case, the employee, the date now, and the mninutes opened). You can read more about the function here.