Forum Discussion

XTREMEITA's avatar
XTREMEITA
New Member
5 years ago

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

  • mahoneypat's avatar
    mahoneypat
    Microsoft 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

    • XTREMEITA's avatar
      XTREMEITA
      New Member

      Hellow m