Argument '4' in CALCULATE function is required.

[waleed111]

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?

[amitchandak · Accepted solution]

@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 ,