Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Argument '4' in CALCULATE function is required.

CSAT% =  VAR _CASTCount =            CALCULATE(([Just Count]),            NPS[Survey Type] ="Overall Satisfaction",            NPS[Survey Result] IN {8,9,10}            )  VAR _ALLCount = ...
  • DimaMD's avatar
    DimaMD
    4 years ago

    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)

DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
4 years ago

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)