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])

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 
Please try

=
SUMX (
    SUMMARIZE ( Master, Master[Model], Master[Submodel] ),
    CALCULATE ( ABS ( SUM ( Orders[units] ) - SUM ( Forecast[Demand] ) ) )
)