Forum Discussion

cammar's avatar
cammar
Frequent Visitor
3 years ago
Solved

DAX for counting rows with multiple filters

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's avatar
    FreemanZ
    3 years ago

    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)
            )
    )

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    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)
            )
    )