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]),
Anonymous
Ok can you olease share a screenshot of the data model view to see the relationships.
sure, here you go: