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...
Anonymous
Not sure to be honest. Please try
Lost_amount3 =
SUMX (
GENERATE (
SUMMARIZE ( 'Date', 'Date'[Jahr], 'Date'[Monta] ),
CALCULATETABLE ( VALUES ( 'Lost_prep'[Cliento] ) )
),
CALCULATE (
[Lost_amount],
CROSSFILTER ( 'Date'[Date], '2_Abfrage_Orderline'[Date], BOTH )
)
)
Lost_amount3 does not match with Lost_amount. DAX seems to be very complicated
Anonymous
It is better to connect and have a direct look at the data. Let me know if this is possible perhaps tomorrow noon Dubai time.Oh this would be so great. How can we connect?