Circular dependencies how to solve?

Hi Anonymous ,

This column measure is seems that you want to calculate each employee total work hours, is it?

if yes please consider using the following expression:

Sum of hours per employee test =
CALCULATE(
    SUM( 'table'[total_hours] ),
    FILTER( 'table', [employee_id] = EARLIER( 'table'[employee_id] ) )
)

If this does not work, please provide some example data without sensitive data.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.