topic Re: DAX for counting rows with multiple filters in DAX Commands and Tips

DAX for counting rows with multiple filters

cammar — Mon, 23 Jan 2023 15:06:05 GMT

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:

Thanks all

FreemanZ — Mon, 23 Jan 2023 15:23:04 GMT

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 — Mon, 23 Jan 2023 15:26:14 GMT

Absolutely Perfect thanks