Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Problem with total sums and data model.

Hello,   I have the following example data:   Model Submodel Sold units demand forecast ABS(sold units-demand) x x1 3 2 1 x x2 4 7 3 x x3 15 4 11 x x4 6 4 2...
  • DimaMD's avatar
    DimaMD
    3 years ago

    hi Anonymous You need two measures

    abs = 
 VAR _abs = SUM('example data'[Sold units]) - SUM('example data'[demand forecast])
 return
 ABS(_abs)


measure_total = SUMX( VALUES('example data'[Submodel]),[abs])

DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
3 years ago

hi Anonymous You need two measures

abs = 
 VAR _abs = SUM('example data'[Sold units]) - SUM('example data'[demand forecast])
 return
 ABS(_abs)


measure_total = SUMX( VALUES('example data'[Submodel]),[abs])