TABLE to show a breakdown sales by product

[LizetteG]

Hello, 

I am trying to create a table (not measure) that sum sales products grouped by id and serial but my code below is not calculating the sum per product, its calculating the total excluding the breakdown by product. What I am missing? 

SUMMARIZECOLUMNS(Table[Product]

   ,"Sales 24mths", CALCULATE( SUMX( SUMMARIZE(

          Table, Table[ID], Table[Serial #], Table[Sales]), Table[Sales]), 

          DATESINPERIOD('Table'[Date Closed], EOMONTH(TODAY(),-2), -25, MONTH)

   )

   ,"Prior Month Sales", CALCULATE( SUMX( SUMMARIZE(

          Table, Table[ID], Table[Serial #], Table[Sales]), Table[Sales]), 

          DATESINPERIOD('Table'[Date Closed], EOMONTH(TODAY(),-1), -1, MONTH)

   )

)

Result:

Product          Prior Month Sales    Sales 24mths

1                     14486                       99786

2                     14486                       99786

3                     14486                       99786

4                     14486                       99786

Thanks!

[AlB]

@LizetteG 

I asked about the input table. Plus the expected result

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[AlB]

@LizetteG 

What does the input table look like? the one that youa re using to generate the result above

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.