Forum Discussion

kky1's avatar
kky1
Helper II
2 years ago
Solved

Argument 3 in CALCULATE function is required - syntax error?

Hello community - I am getting the error "Argument 3 in CALCULATE function is required for this DAX measure. Reading other posts, most of these appear to be a syntax such  as an extra comma but I am ...
  • amitchandak's avatar
    2 years ago

    kky1 , remove comma in this

     

    VAR __selected_gender_sel =
    CALCULATE(
    SUM('Faculty IPEDS Diversity'[Count]),
    'Peer Groups'[UnitID]=__selectedUnitID, //variable selectedInstitution
    )

     

     

    like

     

     

    VAR __selected_gender_sel =
    CALCULATE(
    SUM('Faculty IPEDS Diversity'[Count]),
    'Peer Groups'[UnitID]=__selectedUnitID //variable selectedInstitution
    )