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"
Solved! Go to 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 )
)
)
Thanks !!!
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 )
)
)
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!