topic Re: Backlog Measure in DAX Commands and Tips

Backlog Measure

Anonymous — Thu, 04 Aug 2022 12:16:06 GMT

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 — Thu, 04 Aug 2022 12:38:10 GMT

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

Anonymous — Thu, 04 Aug 2022 13:21:30 GMT

Thank you for the fast reply!