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.