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...
Hi, thanks for the above! I have used the measure (also posted below) but returns:
"The syntax for 'return' is incorrect. (DAX(var_CountedQuantity=CALCULATE(COUNT(CycleCountingWarehouseWorkLinesV3[ExpectedQuantity]),FILTER((ALLSELECTED(CycleCountingWarehouseWorkLinesV3[CountedQuantity]=MAX(CycleCountingWarehouseWorkLinesV3[ExpectedQuantity])))
return DIVIDE([ExpectedQuantity Value],_CountedQuantity)))."