Forum Discussion

ajisharavind_99's avatar
ajisharavind_99
Advocate I
4 years ago
Solved

FILTER NOT VALIDATING

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-...
Need Help
  • VahidDM's avatar
    VahidDM
    4 years ago

    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's avatar
    tamerj1
    4 years ago

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