Forum Discussion

jussiwaisto's avatar
jussiwaisto
Helper 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 al...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    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.

     

amitchandak's avatar
amitchandak
Super 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.

 

jussiwaisto's avatar
jussiwaisto
Helper I
6 years ago

Exactly! Thanks you very much!!