Forum Discussion

Truelearner's avatar
Truelearner
Helper III
6 years ago
Solved

need help with DAX

I have employee hire dates i want to create the Total Employee column  Anonymous cham amitchandak Greg_Deckler Mariusz    Employee Hire date  Name DESIGNATION EMPID Total Employee  01-mar...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Truelearner,

    I'd like to suggest you add distinct function to remove duplicate rows:

    Measure =
COUNTROWS (
    FILTER (
        DISTINCT ( ALLSELECTED ( Table ) ),
        [Hire Date] <= MAX ( Table[Hire Date] )
    )
)

    Regards,

    Xiaoxin Sheng

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

COUNTROWS(FILTER('Table',[Employee Hire Date] <= EARLIER([Employee Hire Date])))

  • Truelearner's avatar
    Truelearner
    Helper III
    6 years ago

    its almost what i needed but the problem is with duplicates with DATA , can you check my table i posted about once.