SUMX vs SUMX w/Summarize

Euro0681 — Tue, 13 Dec 2022 14:44:13 GMT

I have create a measure that sums another measure (reason for this is to correct the totals):

Measure 1 = if([Quantity] < 0 || [Price] < 0 || [Difference] = 0, 0, [Quantity] * [Price])
Measure 2 = SUMX('Table', [Measure 1]) <--- This total is 10,000

I then re-created the same measure using 'SUMMARIZE' trying to help with performance since 'Measure 2' (breaks the visual when applied with other measures)

Measure 3 = SUMX( SUMMARIZE( 'Table', 'Table'[ProductName] ), [Measure 1] ) <--- Total is 9,000

But when using this version, the total is 9,000, Why?
Also I know SUMX is hurting the performance (especially because of the conditional measure) , if anyone has any suggestions helping to optimize it would greatly be appreciated PLEASE and Thank you! (I can only create measure LIVE CONNECTION)

Re: SUMX vs SUMX w/Summarize

FreemanZ — Wed, 14 Dec 2022 02:01:09 GMT

hi Euro0681

Measure 2 scans the whole table, Measure 3 scans the unique list of 'Table'[ProductName]. It seems the 'Table'[ProductName] column has blank rows.

Re: SUMX vs SUMX w/Summarize

Euro0681 — Fri, 16 Dec 2022 15:27:56 GMT

Thanks, I was thinking the same but was just wanting to get confirmation!

topic Re: SUMX vs SUMX w/Summarize in DAX Commands and Tips

SUMX vs SUMX w/Summarize

Re: SUMX vs SUMX w/Summarize

Re: SUMX vs SUMX w/Summarize