SUMX in matrix using column and measure

[lguicarvalho]

Hi, everyone!

I'm trying to multiply the column "Peso" and the measure "Nota", shown in the matrix, in a new measure, called "Nota_pond". As show bellow, we can see that, individually, they work fine in the Matrix. If I multiply then directly, using SelectedValue in "Peso", they work fine too.

Then, I need to get the SUM of all these instances. The problem is that when I use a SUMX function to multiply "Peso" and "Nota", it doesn't return the correct value.

Additionally, trying to debug, I noticed that using SUMX individually with "Peso", it returns the same value of the Column, but the same does not apply to the measure "Nota".

Could anyone help with that?

[amitchandak]

@lguicarvalho , can you share all measures in text format

Please refer this

https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi