topic Re: Subtotal in a new column instead of a measure in DAX Commands and Tips

Subtotal in a new column instead of a measure

Guitarseb — Tue, 17 Nov 2020 23:11:13 GMT

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

Re: Subtotal in a new column instead of a measure

camargos88 — Tue, 17 Nov 2020 23:20:04 GMT

Guitarseb,

Try:

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

Re: Subtotal in a new column instead of a measure

Guitarseb — Tue, 17 Nov 2020 23:25:22 GMT

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

Re: Subtotal in a new column instead of a measure

CNENFRNL — Wed, 18 Nov 2020 00:41:26 GMT

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

Re: Subtotal in a new column instead of a measure

Guitarseb — Wed, 18 Nov 2020 00:44:17 GMT

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

Re: Subtotal in a new column instead of a measure

wdx223_Daniel — Wed, 18 Nov 2020 01:00:30 GMT

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