Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
@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
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |