Need Help Measure SUMX with worng Total

[Anonymous]

Hello dear Community,

Could you help me check why my total doesn't return the right result please?

From the column Potential $, I want to return the total and it should be 2477508 but my total from this cololumn is 2259259 (coming from 1.07*2104791).

Thanks a lot for your help.
Best regards,

This is my Measure: 

Measure Potential $ =

var avg_potential=[Volume]*[Average 3]

return

if(

HASONEVALUE(Plant[Unit]),

avg_potential,

SUMX(values('Table Plant[Unit]),avg_potential))

Unit	Volume	Average 3	Potential $
A1	525514	1,73	908860
A2	161469	1,91	309002
A3	121542	1,85	225162
A4	207223	0,87	181102
A5	109661	1,15	126602
A6	144664	0,80	115472
A7	137494	0,84	115384
A8	118783	0,94	111785
A9	81502	1,26	102720
A10	212206	0,44	93834
A11	88285	1,03	90888
A12	78892	0,90	71214
A13	117556	0,22	25483
	Sum	Average	Sum
Total	2104791	1,07	2259259	Wrong result from measure
	Sum	Average	Sum
Total	2104791	1,07	2477508	Right result

[Anonymous]

This is your measure:

[Measure Potential $] =
    SUMX(
        VALUES( 'Table Plant'[Unit] ),
        [Volume] * [Average 3]
    )

You have to remember that variables, once set, are STATIC.

Best

D

[Anonymous]

Hello @Anonymous , Thanks for the reply but it doesn't work either.

Still get the same result 😞

[AntrikshSharma]

I am getting the correct result, looks like your multiplication in the origianl post is incorrect.

[harshnathani]

Hi @Anonymous ,

Try this measure

Measure Potential $ =
VAR avg_potential = [Volume] * [Average 3]
RETURN
    IF (
        HASONEVALUE ( Plant[Unit] ),
        SUMX (
            'Table Plant',
            avg_potential
        ),
        SUMX (
            VALUES ( 'Table Plant'[Unit] ),
            avg_potential
        )
    )

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @harshnathani  , thanks for your reply but it unfortunately doesn't work.

I end up with the same result at the end 😞