Solved: Backlog Measure

Anonymous · ‎08-04-2022

Hi All,

Could you help me with a backlog measure please, i wish to count all the Task ID's which have a date before today.

Columns -

Task ID -

Task Due Date

Thanks

johnt75 · ‎08-04-2022

Backlog = CALCULATE( DISTINCTCOUNT( 'Table'[Task ID]), 'Table'[Task Due Date] < TODAY())

Anonymous · ‎08-04-2022

Thank you for the fast reply!

johnt75 · ‎08-04-2022

Backlog = CALCULATE( DISTINCTCOUNT( 'Table'[Task ID]), 'Table'[Task Due Date] < TODAY())

Backlog Measure