Dax Measure: How Many Projects Start in the Next 30 Days?

[KMGLarson]

Hi, I have written a measure that I think should work, but it isn't working and I'm hoping someone here can help me troubleshoot. As you can see in the screenshot below, I have a table that shows a list of projects with their mobilization dates. My client wants to track how many projects are mobilizing in the next 30, 60, 90, and 120 days. The measure I've written returns nothing, but as you can see from the table, it should count 2 projects starting in the next 30 days - the 3rd and 4th row respectively on the table.

Here is the measure:
ConStart+30 = CALCULATE(COUNTROWS('Project Tasks'), FILTER('Project Tasks', [Task Name]="Mobilization"), DATESINPERIOD('Calendar'[Dates], TODAY(), 30, day))

Here is the screenshot:

Thanks in advance for any help you can offer!
Kirstin

 

[ExcelToDAX]

This won't 100% work because I am not sure what filters you have in place... but how about:

CALCULATE(COUNTROWS('Project Tasks'), FILTER('Project Tasks', [Task Name]="Mobilization" && [Start] <= TODAY()+30))

 

[KMGLarson]

Thank you-that returns a count, but it counts all 4 instances, where it needs to just count the 2 instances between today and July 28.
But when I took your approach one step further and did did this:

ConStart+30 = CALCULATE(COUNTROWS('Project Tasks'), FILTER('Project Tasks', [Task Name]="Mobilization" && [Start]>=TODAY() && [Start]<=TODAY()+30))

It worked!

Now I can easily create the other 4 measures.
So thank you for the quick and easy solution!