Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

summerize differently depending on filter

Hi, because my "Lost_amount"   does not summarize the total, I have created "Lost_amount3"     But depending on how many customers (=CYname) it summarizes differently.   Correct...
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, thanks for your help again 🙂
    I thought it works, but then I continued all night and now it is empty again. The columns did not change, the relationships did not change. I can't immagine why your code does not work not. So build up on your idea I used the summary table, which is now called "Lost_amount3", but this summarizes strange

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

      Anonymous 
      This way should work

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

        This is empty too. Or do I have to add this code in front of something?