Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

wrong total

Hello, my total for "Lost_amount" is shown as average instead of a summary. It is a measure: Lost_amount = VAR Purchase=CALCULATETABLE(VALUES('6_Lost'[Key]), FILTER(ALL('Date'), 'Dat...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Anonymous 

    Still can be addef to the SUMMARIZE table

    Lost_new =
    SUMX (
    SUMMARIZE(
    '6_Lost'
    '6_Lost'[StartDate],
    '6_Lost'[EndDate],
    '6_Lost'[Product],
    '6_Lost'[CYname],
    'Date'[Jahr],
    'Date'[Monat]
    ),
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Anonymous 

Still can be addef to the SUMMARIZE table

Lost_new =
SUMX (
SUMMARIZE(
'6_Lost'
'6_Lost'[StartDate],
'6_Lost'[EndDate],
'6_Lost'[Product],
'6_Lost'[CYname],
'Date'[Jahr],
'Date'[Monat]
),
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Oh, wow. I did not suspect that it would make a difference by putting it at the end. It works now. 

 

Thanks so much for your help. Really appreciate it 🙂