Forum Discussion
Helper ISum total with date slider?
Hi,
what kind of measure do I need, if I want to SUM € values by using Date slider?
If I use this kind of measure, bit it SUM's ALL data together and date slider won't work at all.
Measure =
CALCULATE(
SUM(Table[€](;
ALL(Table))
This gives result 3600 but it should be 600 (because of January).
What should I add there?
The formula you are using is for GT across. Either remove all(table1)
Measure = CALCULATE( SUM(Table[€])
Or use ALL EXCEPT
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
Measure = CALCULATE( SUM(Table[€](; allexcept(Table[date]))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.
2 Replies
- amitchandak
Super User
The formula you are using is for GT across. Either remove all(table1)
Measure = CALCULATE( SUM(Table[€])
Or use ALL EXCEPT
https://docs.microsoft.com/en-us/dax/allexcept-function-dax
Measure = CALCULATE( SUM(Table[€](; allexcept(Table[date]))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.
jussiwaistoExactly! Thanks you very much!!