Need help with a count expression within a date range

Rod
Bronze 3
Bronze 3

Using this script to count all of the "section a" trips between dates and it sends back all of them, not withing the date range. Here's the script;

COUNT(Select(Trips[Section],
AND(
([Section]= "Section A"),
([Date]>=[_THISROW].[Start Date]),
([Date]<=[_THISROW].[End Date]))))

I've tried using the ID field instead of Section with the same results.

I've tried this one as well with same result.

COUNT(FILTER("Trips",
AND(
([Section] = "Section A"),
([Date]>=[_THISROW].[Start Date]),
([Date]<=[_THISROW].[End Date]))))

0 4 142
4 REPLIES 4

So what's the question?

Rod
Bronze 3
Bronze 3

What's the question? 

As stated in headline of my post, I'm looking for help with an expression regarding a count expression. I'm trying to count how many times the text "Section A" shows up in a column named Section between a specific date range. 

The expressions look right to me.

Rod
Bronze 3
Bronze 3

I have it working now. Thanks!

Top Labels in this Space