Calculate value for total year

[nurulizzaty]

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]), ALL(table[Year]))

return totalData

but this measure does not works.. 

Really need your help on this. 

Thanks & Regards,

Izzaty

[v-yalanwu-msft · Accepted solution]

Hi, @nurulizzaty ;

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.

[amitchandak]

@nurulizzaty , Try like

calculate(sum(table[value]),all())

or

calculate(sum(table[value]),all(Table))