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...
The customers are coming from a table, that selects column from table
relationships are:
tamerj1
Community Champion
Community ChampionAnonymous
Please try
Lost_amount3 =
SUMX (
CROSSJOIN ( VALUES ( 'Date'[Monta] ), VALUES ( 'Lost_prep'[Cliento] ) ),
[Lost_amount]
)