Forum Discussion
Solved
problem with filter function in my expression
Hello Guys, I am using an excel file as my data source. I am working with my table product at the moment specifically with the fields Sales Revenue and States. I want to create a new measure on t...
I think the issue is that second VAR evaluates the SUM before the filter context from the first VAR is applied, so it returns a scalar value
CALCULATE(SUM(Produits[Sales_revenue]),NewYorkSales)
should work fine
