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 )
)
)
User | Count |
---|---|
93 | |
32 | |
31 | |
17 | |
14 |
User | Count |
---|---|
100 | |
27 | |
21 | |
17 | |
16 |