Forum Discussion

rsbin's avatar
rsbin
Community Champion
1 year ago
Solved

Find Terminated Employees

Good Day Folks, Looking for some guidance on this one.  Have the following Employee Data Table: EmployeeID PointinTimeID Status StartDate EndDate Terminated Flag 1 4840 ...
Need Help
  • ThxAlot's avatar
    ThxAlot
    1 year ago

     

    Flag =
VAR __id = EMPL[EmployeeID]
RETURN
    CALCULATE(
        NOT ISEMPTY( EMPL ),
        ALL(),
        EMPL[EmployeeID] = __id,
        EMPL[Status] = "Terminated"
    ) + 0

     

     

     

    Flag =
CALCULATE(
    NOT ISEMPTY( EMPL ),
    ALLEXCEPT( EMPL, EMPL[EmployeeID] ),
    EMPL[Status] = "Terminated"
) + 0

     

ExcelMonke's avatar
ExcelMonke
Impactful Individual
1 year ago

No problem, have you considered the ALLEXCEPT function? 

rsbin's avatar
rsbin
Community Champion
1 year ago

ExcelMonke ,

Yes, I have considered the ALLEXCEPT function.
But haven't been able to successfully get a complete DAX expression to work the way I need it to.