Forum Discussion
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...
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
Community Champion
Community ChampionAnonymous
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]
)This is empty too. Or do I have to add this code in front of something?
- tamerj1
Anonymous
Please share a screenshot along with the dax code you wrote.These are all codes I used in the visual