Forum Discussion
XTREMEITA
5 years agoNew Member
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:
2 Replies
- mahoneypatMicrosoft Employee
Not 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
- XTREMEITANew Member
Hellow mahoneypat,
Thanks for me answering, but see what happened.