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.
