Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculate value for total year

Hello experts, I want to calculate value for total year. In my data, I have value for year 2019-2023.  The measure that i want to do is like below:    var totalData = calculate(sum(table[value])...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Anonymous ;

    You could try it.

    Measure = 
CALCULATE(SUM('table'[value]),ALLEXCEPT('table','table'[Year]))

    the final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous ;

You could try it.

Measure = 
CALCULATE(SUM('table'[value]),ALLEXCEPT('table','table'[Year]))

the final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.