Forum Discussion

jussiwaisto's avatar
jussiwaisto
Icon for Helper I rankHelper I
6 years ago
Solved

Sum 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?

Need Help
Show and Tell

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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.