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]))
Looks like you are over-thinking it.
Just use a simple SUM. If you want a better model ,put Month and Category in dimension tables - linked 1:m with the main fact table