SUMX Incorrect Values

[Euro0681]

I Have created a Measure (Measure 1) and then created another measure (Measure 2) to try and correct the totals and it's giving wrong values at a row level causing the total to be wrong as well.

Column = Sales Amount from Table
Rate = Column from Table 
Measure 1 = Column * Rate
Measure 2 = SUMX( 'Table', [Measure 1] )

Measure 2 is incorrect on row level causing total to be incorrect?? any suggestions?

[Anonymous · Accepted solution]

Hi  @Euro0681 ,

Here are the steps you can follow：

1. Create measure.

If you want to display Total at the end, you can use the following function:

Measure2 =
var _table1=SUMMARIZE('Table', 'Table'[Column],"Value",[Measure1])
return
IF(
    HASONEVALUE('Table'[Column] ),
    [Measure1],SUMX(_table1,[Value]))

If you want to display Total in full, you can use the following function:

Measure 3 = SUMX(ALL('Table'),[Measure1])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[FreemanZ]

hi @Euro0681 

can you show the code for measure 1?

[Anonymous]

Try SUM() instead of SUMX()

[Euro0681]

I cant use SUM to sum up a measure.. EXAMPLE: SUM([Measure 1])