Suming a measure

[Anonymous]

Hi everyone,

First two columns are not measures, other are all measures. I Want to create a measure to sum the last column. i tried this: 

Suma Elasticidades solo contacto filas considerar = SUMX(Combinar1,[Suma Elasticidades para sacar elasticidad material]) but the value is a litle bit incorrect.

I also tried this: 

SumarSi = SUMX(Filter( VALUES(Combinar1[NumSem]) , [Measure Filter] = 1 ), [Suma Elasticidades para sacar elasticidad material])

The result is incorrect too.

I hope someone can help me 😄

[PabloDeheza · Accepted solution]

Hi there!

It would look something like this

SUMX( ADDCOLUMNS( SUMMARIZE( Table, NumSem, AñoSemOrd), "@Measure", [Suma Elasticidades para sacar elasticidad material], [@Measure]

Let me know if that helps!

[Anonymous]

it worked perfectly.

Ty vry much.

[Anonymous]

Ty vry much for responding.

What do you refer with "@Measure". The name of my new measure?

[PabloDeheza]

the measure uses ADDCOLUMNS, so "@Measure" y the name of the new column you are adding on your calculation, its just a name. The thing is that its a good practice to use @ on new columns created when using  ADDCOLUMNS or any other function that lets you do that, it helps to identify them