Forum Discussion
DQV In Power BI Service does not return Same Count or Total Amount as Manual Filter Table in PBIX
Hi tecumseh,
Great follow-up. The error comes from how SUMMARIZECOLUMNS expects its filter arguments: each filter must be a table expression, not a Boolean expression. In other words, you can’t put Bookings[Date] = DATE(...) directly inside SUMMARIZECOLUMNS. Wrap your predicates in a table expression like FILTER(ALL(Bookings), ...), and place that table as its own argument.
EVALUATE SUMMARIZECOLUMNS( Bookings[Advertiser], Bookings[Order #], Bookings[Date], -- filter tables must be table expressions (NOT booleans): FILTER( ALL(Bookings), Bookings[Advertiser] = "xCustomer" && Bookings[Date] >= DATE(2025,8,1) && Bookings[Date] < DATE(2025,8,2) -- half-open day range ), -- prefer your measure for totals if you have one: "Total Revenue", [Net Revenue] -- or CALCULATE(SUM(Bookings[Net Revenue])) )If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Thanks tayloramy
1 & 2 returned the same as OP so no help there.
I'm trying SUMMARIZECOLUMNS, but I'm getting an error in the FILTER clause.
Thoughts on what I'm doing incorrectly?
Thanks,
w
EVALUATE
SUMMARIZECOLUMNS(
Bookings[Advertiser],
Bookings[Order #],
Bookings[Date],
"Total Revenue", SUM(Bookings[Net Revenue]),
FILTER(
Bookings[Date] = DATE(2025,08,01) &&
Bookings[Advertiser] = "xCustomer"
)
)M
Hi tecumseh,
Great follow-up. The error comes from how SUMMARIZECOLUMNS expects its filter arguments: each filter must be a table expression, not a Boolean expression. In other words, you can’t put Bookings[Date] = DATE(...) directly inside SUMMARIZECOLUMNS. Wrap your predicates in a table expression like FILTER(ALL(Bookings), ...), and place that table as its own argument.
EVALUATE
SUMMARIZECOLUMNS(
Bookings[Advertiser],
Bookings[Order #],
Bookings[Date],
-- filter tables must be table expressions (NOT booleans):
FILTER(
ALL(Bookings),
Bookings[Advertiser] = "xCustomer"
&& Bookings[Date] >= DATE(2025,8,1)
&& Bookings[Date] < DATE(2025,8,2) -- half-open day range
),
-- prefer your measure for totals if you have one:
"Total Revenue", [Net Revenue] -- or CALCULATE(SUM(Bookings[Net Revenue]))
)If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.