Summarize with filtered measure

DAX DAX Calculations
2

@nainu,

Try this:

Virtual Table Filtered = 
FILTER(
    SUMMARIZE(
        Regions, Regions[City],
        "Total City Sales", [Total Sales]
    ),
    [Total City Sales] > 1000000
)

I’ve not seen that “invalid bindings” error before , but “1,000,000” (as opposed to 1000000) in your filter condition will cause problems.

  • Brian

image