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...
  • 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)
            )
    )
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)
        )
)
  • cammar's avatar
    cammar
    Frequent Visitor
    3 years ago

    Absolutely Perfect thanks