Subtotal in a new column instead of a measure

[Guitarseb]

Hello Experts,

I have a table with some years and some value. I want to have the sum of all the value on each rows but using a column instead of a measure. If I use the following same formula on the column and on the masure I don't get the same result when I change the data filter. How do I have to change the formula in order to have the same result I have in the measure?

THis is the formula I used on both column and measure

CALCULATE(sum(Tabella[value]),ALLSELECTED(Tabella))

These are the result changing the year filter

[wdx223_Daniel]

@Guitarseb in calculated column, the calculation can not get the value in any slicer.

[CNENFRNL · Accepted solution]

@Guitarseb , the Column is a calculated column, isn't it? A calculated column is irrelevant to any slicers whereas a measure is so.

[Guitarseb]

Yes it is. Indeed you are right so it is not possible...

[camargos88]

@Guitarseb,

Try:

CALCULATE(sum(Tabella[value]),ALL(Tabella))

[Guitarseb]

Thanks for your reply

WIth ALL the column has the same behaviour. If i use it on the measure it works like the column giving always the value 3803 even if I change the year filter and this is not what I want