Sum total with date slider?

[jussiwaisto]

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?

[amitchandak · Accepted solution]

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.

[jussiwaisto]

Exactly! Thanks you very much!!