Forum Discussion
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...
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
Community Champion
Community ChampionAnonymous
Can you please share the code that you have used? What columns are placed in the table visual?
My fault. Indeed it was not complete. Two columns are in the visual too, which come from a date table: