Argument '3' in if function is required - Table

[shantupm5]

Hello

I am getting error Argument '3' in if function is required. May i know know what is missing with this DAX?

JL Wise Completion Rate =

var _pass =

CALCULATE(

    COUNT(Qualicom[EmpNo]),

    FILTER(

        ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name]),

        'Training Details Fy 22'[Pass/Fail_1] = "Pass"

    )

)

var _total =

CALCULATE(

    COUNT(Qualicom[EmpNo]),

    ALLEXCEPT('Training Details Fy 22','Training Details Fy 22'[Program Name]),

)

var _res = DIVIDE(_pass, _total, 0)

return

IF(ISBLANK(_res),0, _res)

Regards

Prashanth

[shantupm5 · Accepted solution]

This is resolved TQ