Forum Discussion

Euro0681's avatar
Euro0681
Helper II
3 years ago
Solved

SUMX vs SUMX w/Summarize

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) 

  • 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.

2 Replies

  • 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's avatar
      Euro0681
      Helper II

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