Forum Discussion
New Measure - Percentage based on two quantities
Morning All, I've used commnity support in the past on things such as VBA and again more recently following a D365 go-live and learning to link PBI and Dynamics.. From pulling a warehouse cycl...
So the solution I have managed to get to work is:
Measure 1
Accuracy =
VAR OnHand = SUM(CycleCountingWarehouseWorkLinesV3[ExpectedQuantity])
VAR CountedQuantity = SUM(CycleCountingWarehouseWorkLinesV3[CountedQuantity])
VAR MinValue = MIN(OnHand, CountedQuantity)
VAR MaxValue = MAX(OnHand, CountedQuantity)
VAR Accuracy = IF(MaxValue = 0,0,DIVIDE(MinValue, MaxValue, 0))
RETURN Accuracy * 100
Measure 2
Measure 2
AverageAccuracy = Averagex(CycleCountingWarehouseWorkLinesV3,[Accuracy])