topic Re: SUMX Incorrect Values in DAX Commands and Tips

SUMX Incorrect Values

Euro0681 — Tue, 20 Dec 2022 20:03:02 GMT

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?

Re: SUMX Incorrect Values

Anonymous — Tue, 20 Dec 2022 20:16:28 GMT

Try SUM() instead of SUMX()

Re: SUMX Incorrect Values

Euro0681 — Tue, 20 Dec 2022 20:31:18 GMT

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

Re: SUMX Incorrect Values

FreemanZ — Tue, 20 Dec 2022 21:09:54 GMT

hi Euro0681

can you show the code for measure 1?

Re: SUMX Incorrect Values

Anonymous — Wed, 21 Dec 2022 03:15:38 GMT

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