topic Argument '4' in CALCULATE function is required. in DAX Commands and Tips

Argument '4' in CALCULATE function is required.

Anonymous — Wed, 28 Sep 2022 11:45:29 GMT

CSAT% =

VAR _CASTCount =

CALCULATE(([Just Count]),

NPS[Survey Type] ="Overall Satisfaction",

NPS[Survey Result] IN {8,9,10}

)

VAR _ALLCount =

CALCULATE([Just Count],

All(NPS),

NPS[Source Type] = "Overall Satisfaction",

)

RETURN

DIVIDE(_CASTCount,_ALLCount)

I am getting this error how to fixed it

Re: Argument '4' in CALCULATE function is required.

DimaMD — Wed, 28 Sep 2022 12:10:04 GMT

Anonymous hi, try it, You have a coma left

CSAT% =

VAR _CASTCount =

CALCULATE(([Just Count]),

NPS[Survey Type] ="Overall Satisfaction",

NPS[Survey Result] IN {8,9,10}

)

VAR _ALLCount =

CALCULATE([Just Count],

All(NPS),

NPS[Source Type] = "Overall Satisfaction"

)

RETURN

DIVIDE(_CASTCount,_ALLCount)

Re: Argument '4' in CALCULATE function is required.

Anonymous — Wed, 28 Sep 2022 14:05:06 GMT

Thank you got it