Get Row Count and filter specific columns

[gco]

Hi there,

I am trying to create a measure that counts the number of rows and filter by 2 columns.  And i am not able to figure it out.  Any help would be much appreciated.

Here is an example:

AccountNumber/OpenDate/LogonDate

Measure counts the rows if OpenDate and LogonDate is between Now()-29 and Now().

I tried the one below, but i get an error saying there are multiple values.

CALCULATE(COUNTROWS(Accounts), 

FILTER (Accounts,

            DATESBETWEEN(Accounts[OpenDate],NOW()-29,NOW()) &&

            DATESBETWEEN(Accounts[LogonDate],NOW()-29,NOW())))

Thank you

Glen

[gco · Accepted solution]

I was able to fix my issue by creating a new table filtered by Open Date.  And then by adding relationship between the 2 tables.