Forum Discussion

gco's avatar
gco
Resolver II
7 years ago
Solved

Get Row Count and filter specific columns

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

  • 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.

1 Reply

  • gco's avatar
    gco
    Resolver II

    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.