Count based on condition - A table of multiple values was supplied where a single value was expected

[Alejotecelec]

Hello, 

I'm trygin to count the number of rows that meet the criteria specified in Filter however the results is "A table of multiple values was supplied where a single value was expected"

AcquisitionFY22 = CALCULATE(

                            COUNTROWS(Donors),

                                    FILTER(Donors,

                                     DATESBETWEEN(Donors[Added_Date],DATE(2021,04,01),DATE(2022,03,31))))

Table snip: 

[Alejotecelec]

Thanks !!!

[johnt75 · Accepted solution]

FILTER needs a boolean expression as its second argument, try this instead

AcquisitionFY22 =
CALCULATE (
    COUNTROWS ( Donors ),
    DATESBETWEEN (
        Donors[Added_Date],
        DATE ( 2021, 04, 01 ),
        DATE ( 2022, 03, 31 )
    )
)