Argument '3' in if function is required

Question

Hello&nbsp;I am getting error&nbsp;Argument '3' in if function is required. May i know know what is missing with this DAX?&nbsp;JL Wise Completion Rate =var _pass =CALCULATE(&nbsp; &nbsp; COUNT(Qualicom[EmpNo]),&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name]),&nbsp; &nbsp; &nbsp; &nbsp; 'Training Details Fy 22'[Pass/Fail_1] = "Pass"&nbsp; &nbsp; ))var _total = CALCULATE(&nbsp; &nbsp; COUNT(Qualicom[EmpNo]),&nbsp; &nbsp; ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name]),)var _res = DIVIDE(_pass, _total, 0)returnIF(ISBLANK(_res),0, _res)&nbsp;RegardsPrashanth

shantupm5 · Accepted Answer

This is resolved TQ

Forum Discussion

Argument '3' in if function is required - Table

1 Reply

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Argument '2' in CALCULATE function is required.

Argument '10' in SWITCH function is required

Argument 8 in SWITCH function is required