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
2 years ago

Hi anushaghi123 

please try

Product_Count rolling average correct total =
SUMX (
SUMMARIZE (
'Table_name',
'Table_name'[dimdate].[Year],
'Table_name'[dimdate].[QuarterNo],
'Table_name'[dimdate].[Quarter],
'Table_name'[dimdate].[MonthNo],
'Table_name'[dimdate].[Month]
),
[Product_Count rolling average]
)

anushaghi123's avatar
anushaghi123
Helper II
2 years ago

Thanks so much tamerj1 . It is working but now only showing till current month not the forecast data for October month like below.