Total of new measure does not sum correctly

[Monami]

Hi!

I'm new to DAX, and am trying to create a formula that will calculate the price deviation, but the total does not sum the rows, but instead returns the calculated result on the total. 

This is what i'm using:

=([Price per KG - Actual] - [Price per KG - Budget]) * [Sum of RM Weight Sold ADJ M (2023)]

Please help!

[tamerj1]

Hi @Monami 
Please try

=
SUMX (
    VALUES ( Conso[Product] ),
    ( [Price per KG - Actual] - [Price per KG - Budget] ) * [Sum of RM Weight Sold ADJ M (2023)]
)

[Monami]

thanks Andhiii,

I added the SUMX, but it uses the underlying data. is there any way for the formula to calculate the formula based only on the table presented ? (without the underlying) 

[andhiii079845]

Please make a example table, your current measure, the wrong result and what you want 🙂

[Monami]

hope this is clear enough

[andhiii079845]

Can you please show the underlaying table? Some data record would be great, are there more rows with repeting price budget and actual? Than you have to use maxx or minx.

[andhiii079845]

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