Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
47 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |