FILTER NOT VALIDATING

[ajisharavind_99]

Hi,  

I tried to add a new column in my table with below dax but the first filter condition is not validating (FHC[Available] = "IFC"), Only validating  the last 2 filters .  

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

[VahidDM · Accepted solution]

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 

[tamerj1 · Accepted solution]

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] )

[ajisharavind_99]

Thank you very much @VahidDM 

[VahidDM · Accepted solution]

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