I am watching the tutorial about using the function summarize and the example is showed below:
I am wondering is that possible to put a filter on the measure of total sales? for example, only total sales larger than 1,000,000 will be summarized in this table. I tried this:
VAR NoFilter = SUMMARIZE(‘Regions Table’, ‘Regions Table’[City], “Total Sales”, [Total Sales])
FILTER(NoFilter, [Total Sales] >1,000,000)
but, it showed an error said “invalid bindings specified”. What is the correct way to achieve this? thanks!