Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Composite goal help

I have been trying to come up with a composite measure for the report I am generating. The report is for a distribution facility where the warehouse workers could work in multiple zones in a work day.  Each work zone has it's own assigned goals.

 

For instance Worker Jane Smith works for 8 hours in her shift.  During her work day she picks 102 lines.

ZoneLines Picked% of User total(Lines picked/Total Lines)Zone goal% of Total x Zone goal
A1.009825.245

B

80.78433527.450
C20.1961183.53
D1.0098222.45

 

Adding up the right column should show 31.47 as composite goal per hour.

 

any suggestions on how to do this in dax? Lines picked is already a Dax measure where it is a count of transaction IDs. Zone Goals are determined as a nested IF statement in it's own measure.

 
If(SELECTEDVALUE(Rolling3RFData[Picking Area], "Other" ) = "Zone A", ZoneALinesHourGoal,
If(SELECTEDVALUE(Rolling3RFData[Picking Area], "Other" ) = "Zone B", ZoneBLinesHourGoal,
If(SELECTEDVALUE(Rolling3RFData[Picking Area], "Other" ) = "Zone C", ZoneCLinesHourGoal,
If(SELECTEDVALUE(Rolling3RFData[Picking Area], "Other" ) = "Zone D", ZoneDLinesHourGoal, GenLinesHourGoal))))

 

Thanks in advance for any help you can provide.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    Hi Anonymous 

    What do you mean by

    "Adding up the right column should show 31.47 as composite goal per hour."

     

    Could you please tell what output with what logic are you expecting?

     

    Thanks,

    Pravin