Composite goal help

[Anonymous]

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.

Zone	Lines Picked	% of User total(Lines picked/Total Lines)	Zone goal	% of Total x Zone goal
A	1	.0098	25	.245
B	80	.7843	35	27.450
C	20	.1961	18	3.53
D	1	.0098	22	2.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.

[Anonymous]

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