Forum Discussion
Error Calculate
I raised it in the following way and achieved the expected result.
Do you think it is a good alternative?
CALCULATE( SUM(Worksheet[LE Volume]), KEEPFILTERS(Worksheet[Month]=Worksheet[Month]), KEEPFILTERS(Worksheet[Category]=Worksheet[Category]))
ALLEXCEPT removes all filters except the ones added as parameters. So that's why it doesn't respond to a change in Region.
What is it you are trying to show in the visual? (because Abril is the only month in the data) - it looks like a simple SUM is what's required but maybe you can explain further
I only want to find the sum of LE Volume grouped by month and category, that when filtering by region said calculation shows the result corresponding to each category according to the applied filters. The month is included because at some point the database will have more data per month.
ALLEXCEPT is the function that I have come closest to the result with, but even including the region field as a filter argument, my calculation remains static even when applying filters.