Count number of tasks due in x to y days

[mjackson122]

I have tried several formulas to return the correct number of tasks due within 30, 60, 90 days on a card visual. The formulas I've tried either return a blank or count all of the tasks. The scenario I am trying to fulfil is the following. I want to display the number of tasks due in up to 90 days on a card. The card formula should count tasks that are due within 61 and 90 days from today. I have one table with start, end dates, and days due. The card should also show a 0 instead of a blank if the results are 0. The formula should not count tasks with negative days due

Current formula

upcoming90 = CALCULATE(COUNT(LeadIndicators[End]),LeadIndicators[End]=TODAY()+90)

Sample Data

Start End Days Due

1/1/19 3/1/19 -18

1/1/19 6/15/19 88

1/1/19 4/15/19 27

1/1/19 2/25/19 22

1/1/19 6/15/19 88

1/1/19 3/1/19 -18

So for the upcoming 61-90 scenario I should get a return result of 2.

[Greg_Deckler]

Probably should be something like:

upcoming90 = 
VAR __table = FILTER(ALL('LeadIndicators'),[End]>=TODAY()+60 && [End]<=TODAY()+90)
RETURN
COUNTX(__table,[End])

[mjackson122]

Thanks Greg, unfortunately that returned a value of 12 instead of 2.

[Greg_Deckler · Accepted solution]

I disagree. See attached Page 5, Table 8