Measure counts date field and filters on date

[Anonymous]

Hi guys, 

I am currently trying to create a measure that counts a date field and filters on the date. The measure looks something like this 

New Contract Fiscal YTD = CALCULATE(COUNT('TableName'[Agreement Date]), FILTER('TableName', 'TableName'[Agreement Date] >= 4/1/2021))

It brings me back a count of the field but does not filter it down based on the date I put in. Any thoughts ?? 

[v-cazheng-msft · Accepted solution]

Hi @Anonymous 

Please make a little bit change to your Measure like this:

New Contract Fiscal YTD = CALCULATE(COUNT('TableName'[Agreement Date]), FILTER('TableName', 'TableName'[Agreement Date] >= DATE(2021,4,1)))

Then you should see the result like this:

Best Regards,

Community Support Team _ Caiyun

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This worked perfectly! Thanks for that. I have a quick question, I wanted to do something similar like this but have the filter be the oldest date that is active in the table. I created a measure that grabs the oldest date that is active then tried to use that as the filter. Any suggestions? 

Oldest Exp Date Amount = CALCULATE(SUM('TableName'[Contract Amount]), FILTER('TableName',[Oldest Expiration Date]))

and this is what the oldes expiration date measure looks like 

Oldest Expiration Date = CALCULATE(MIN('TableName'[Expiration Date]), FILTER('TableName', 'TableName' Fields'[Status] = "Active"))

[rodrigosan]

Hello friend, see if this solution suits you.
I made the file available in my folder on GitHub:

https://github.com/roolsant/SOSPowerBI/blob/main/wsmith1.zip

What I did was create a measure of COUNT and then I created another one by applying the filter.
it is possible to apply the filter directly as below:
But I use the date in numeric format:
CountFiltered = CALCULATE(COUNT(fSales[Date]), fSales[Date] >= 44200)