Forum Discussion
Solved
Error Calculate
Hello, again looking for help in the community. I find myself building a SUMIFS, which sums the LE Volume field, grouped by region and category. The DAX I have at the moment is the following: ...
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 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]))