FILTER NOT VALIDATING

Hi ajisharavind_99 

Is there any relationship between Employee_ID and Available tables?

BTW, try this:

Bonuse_Issued_Code-1/2 =
CALCULATE (
    COUNTA ( 'FHC'[Employee_ID] ),
    FHC[Available] = "IFC"
        && FHC[Employee_location] <> BLANK ()
        && OR ( FHC[Bonuse_Issued] = "2", FHC[Bonuse_Issued] = "1" )
)

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

Hi ajisharavind_99 

please try

Bonuse_Issued_Code-1/2 =
VAR T1 =
    CALCULATETABLE ( FHC, ALLEXCEPT ( FHC, FHC[Available] ) )
VAR T2 =
    FILTER (
        T1,
        HC[Employee_location] <> BLANK ()
            && OR ( FHC[Bonuse_Issued] = "2", FHC[Bonuse_Issued] = "1" )
    )
RETURN
    COUNTAX ( T2, 'FHC'[Employee_ID] )