Soma dos Quadrados (SUMX)

[Vilmar]

Ola
Por que tem diferença no total das duas fórmulas da SUMX, sendo que as duas são praticamente iguais?

Valor = SOMA ( Tabela[Venda]

Correto = SUMX ( Tabela;[ Valor]^2 )

Errado = SUMX ( Tabela; SUM( Tabela[Venda] ^ 2 )

[TomMartens · Accepted solution]

Hey,

this is because of the following effects

• implicit filters applied by row/column headers and axis values, in your example an implicit filter is created by the value from column Produto
• the context transition (row context is transformed into filter context whenever a measure is used
• the absence of an implicit filter in the total line

My assumption about the content of your table Tabely: 3 rows

The value from column Errado in the total line is the result of the following calculation:

Three iterations, for each iteration the value for SUM(...[Venda]) is 12, as there is no context transition (explicitly by using the formula CALCULATE(...) or implicitly by referencing a measure); 12^2 equals 144 times 3 (three iterations) equals 432.

This is happening in the total line of the column Correto:

Once again 3 iterations, each time the measure [Valor] is referenced, referencing a measure also means that a context transition is transformed, the row context (SUMX is an iterator function) is transformed into a filter context. Product AA becomes a filter, BB becomes a filter, CC ...

For this reason the SUM of these iterations producing the result of 56: 2^2 (valor filtered by AA) + 4^2 (valor filtered by BB) + 6^2 (valor filtered by CC) 

Please allow me to direct your attention to this blog post: https://www.minceddata.info/2020/03/04/dax-universal-truths/

Hopefully, this explains what is happening.

Kind regards, and happy holidays

Tom

stay safe, stay healthy 

[parry2k]

@TomMartens Well explained my friend. Keep it up!! 💪

[parry2k]

@Vilmar I don't know spanish but here is how you will do it , add as a measure

Errado = SUMX ( Tabela, CALCULATE( SUM ( Tablea[Venda] ) ^ 2 ) )

Would appreciate Kudos 🙂 if my solution helped.Ask anything Power BI. Book appointment for a free consultancy at https://www.perytus.com 

[Greg_Deckler]

Isso parece um problema total de medidas. Muito comum. Veja meu post sobre isso aqui: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Além disso, esta medida rápida, totais de medida, a palavra final deve obter-lhe o que você precisa:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907 desculpas pelo meu português, vem do Bing.

No entanto, no seu caso, eu acho que você está esquartejando seus números e, em seguida, resumir-los em sua segunda fórmula.