cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alejotecelec
Frequent Visitor

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

 

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_1-1674829996480.png

 

 
1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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

View solution in original post

2 REPLIES 2
Alejotecelec
Frequent Visitor

Thanks !!!

johnt75
Super User
Super User

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

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors