SUMX vs SUMX w/Summarize

[Euro0681]

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) 

[FreemanZ · Accepted solution]

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.

[Euro0681]

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