DAX for counting rows with multiple filters

[cammar]

Hi Everyone,

I am trying to create a DAX function where I count Rows based off of mutliple filters. 

I need 

Number of Referrals = Countrows with these filters:

• Status is Active, Allocated or Pending allocation 
• Status Change is on or after 01/10/2022
• First Contact Date is between 01/10/2022 and 31/12/2022

Thanks all

[FreemanZ · Accepted solution]

hi @cammar 

try like:

Number of Referrals =

COUNTROWS(

    FILTER(

        ALL(TableName),

        TableName[Status] IN {"Active", "Allocated", "Pending allocation"}

            &&TableName[Status Change] >=DATE(2022, 10, 1)

            &&TableName[First Contact Date]>=DATE(2022, 10, 1)

            &&TableName[First Contact Date]<=DATE(2022, 12, 31)

        )

)

[cammar]

Absolutely Perfect thanks