Running total countdown

Hi Anonymous - Hope date table is created in your model,

Create a measure to calculate the total number of issues as below:

Total Issues = COUNT('RRP Identified Issues (2)'[Issue ID])

Create another measure to calculate the number of issues expected to close by each quarter

Issues Closed by Quarter =
CALCULATE(
COUNT('RRP Identified Issues (2)'[Issue ID]),
FILTER(
'RRP Identified Issues (2)',
'RRP Identified Issues (2)'[Issue Original Due_x] <= MAX('Date'[Date])
)
)

for running countdown of issues

Running Countdown =
VAR TotalIssues = [Total Issues]
VAR IssuesClosedToDate =
CALCULATE(
[Issues Closed by Quarter],
FILTER(
ALL('Date'),
'Date'[Date] <= MAX('Date'[Date])
)
)
RETURN
TotalIssues - IssuesClosedToDate

above running countdown starts from the total number of issues and decreases based on the issues over the quarters

Hope the above measure helps to resolve.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!