Data Aggregation issue

Flash9883 

Based on the limited information you have shared here, I guess you need to include the employee number in the logic as each row belongs to an employee and you need to het the aggregate in the same manner, try this, replace the employee number in the with your correct column:

SUMX (
    SUMMARIZE (
        FILTER ( TRC_Table, TRC_Table[TRC] IN { "REG", "WRKHM" } ),
        TRC_Table[EmployeeNo], 
        TRC_Table[Date],
        "UniqueCount", DISTINCTCOUNT ( TRC_Table[Date] )
    ),
    [UniqueCount]
)

Hi Flash9883 ,

Please consider marking it as the Accepted Solution if it helped resolve your issue. It will be helpful for others in the community who might be facing a similar problem.

Thank you for your understanding.