Forum Discussion

Euro0681's avatar
Euro0681
Icon for Helper II rankHelper 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 ...
  • FreemanZ's avatar
    3 years ago

    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.