Forum Discussion
Sumx sum if
Hellow, II know I'm doing it wrong, because the total (yellow) is not the value I want, and I want the sum of the red part. Thanks Meassure:
mahoneypat
Microsoft Employee
Microsoft EmployeeNot sure which columns are in which table, but here is the pattern to use. It references your current measure and should give you the right values in rows and total.
New Measure = SUMX(SUMMARIZE(Table, Table[Date], Table[Grupo]), [Amount Projecting])
Regards,
Pat
Hellow mahoneypat,
Thanks for me answering, but see what happened.
