Forum Discussion
waleed111
Helper V
Helper VArgument '4' in CALCULATE function is required.
when i write this formula:
in inventory = CALCULATE(DISTINCTCOUNT('Stock in'[ Serial Number]), 'Stock in'[Tag Device]<>0, 'Stock in'[Non Tag Device]<>0,, 'Stock in'[Number of Dump Truck]<>0, 'Stock in'[Number of Combo]<>0, NOT(ISBLANK('Stock in'[Product Received ])))
it show me this error:
Argument '4' in CALCULATE function is required.
what the problem?
waleed111 , Try like
in inventory = CALCULATE(DISTINCTCOUNT('Stock in'[ Serial Number]), 'Stock in'[Tag Device]<>0, 'Stock in'[Non Tag Device]<>0, 'Stock in'[Number of Dump Truck]<>0, 'Stock in'[Number of Combo]<>0, NOT(ISBLANK('Stock in'[Product Received ])))
there was an additional ,
1 Reply
- amitchandak
Super User
waleed111 , Try like
in inventory = CALCULATE(DISTINCTCOUNT('Stock in'[ Serial Number]), 'Stock in'[Tag Device]<>0, 'Stock in'[Non Tag Device]<>0, 'Stock in'[Number of Dump Truck]<>0, 'Stock in'[Number of Combo]<>0, NOT(ISBLANK('Stock in'[Product Received ])))
there was an additional ,