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 

You need to add these two columns to the SUMMARIZE table

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Do you mean in the SUMMARIZE code? 

 

Lost_new =
SUMX (
SUMMARIZE ('Date','Date'[Jahr],'Date'[Month_txt],
'6_Lost'
'6_Lost'[StartDate],
'6_Lost'[EndDate],
'6_Lost'[Product],
'6_Lost'[CYname]
),
 

These two dates comes from another table and I cannot add them. two tables in summarize code, is this possible?
Sorry, I am still learning DAX and I think I have add it wrong, because the code is not working. 

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Anonymous 

    Ok can you olease share a screenshot of the data model view to see the relationships.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      sure, here you go:

       

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