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 for one customer:

 

Something else instead of Total for more customers. (It is not even the average. No clue what it is summarizing)

 

Some ideas how this can be fix?

 

Thanks

 

 

20 Replies

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