Guitarmageddon
Board Regular
- Joined
- Dec 22, 2014
- Messages
- 161
Hello all, so I have a long list of SKUs and the purchase orders they have been ordered on. I'm getting a sense of SKU-level fill rate percentage.
I have added a measure for distinct count of items that the purchase orders were on. I'm trying to take it a step further : when I expand out the "style desc" column as you can see in row 8, how can I get the DAX to tell me the fill rate math (qty received divided by qty ordered) for the TOTAL parent PO, irrespective of whatever SKU I am looking at. So for example, when I expand out column C like Ive done here, it would show me the total fill rate for ALL items that PO had seen. Hopefully that makes sense. So basically, while I can see that PO 2260994 had a fill rate of 200% on that specific item, as a whole for all SKUs ordered,the PO fill rate could have been 50% lets say.
note: fill rate , distinct PO, are dax measures. The rest is source data.
and for a quick glimpse of source data, its like this
I have added a measure for distinct count of items that the purchase orders were on. I'm trying to take it a step further : when I expand out the "style desc" column as you can see in row 8, how can I get the DAX to tell me the fill rate math (qty received divided by qty ordered) for the TOTAL parent PO, irrespective of whatever SKU I am looking at. So for example, when I expand out column C like Ive done here, it would show me the total fill rate for ALL items that PO had seen. Hopefully that makes sense. So basically, while I can see that PO 2260994 had a fill rate of 200% on that specific item, as a whole for all SKUs ordered,the PO fill rate could have been 50% lets say.
note: fill rate , distinct PO, are dax measures. The rest is source data.
and for a quick glimpse of source data, its like this