Issues using measure in a summarize

[Anonymous]

Hello All,

I use the below dax to calculate monthly P&L €, which is the difference between currant month's unrealized P&L and previous month:

P&L € = CALCULATE(SUM('Unrealized P&L per Month'[Unrealized P&L €]),DATESMTD('Unrealized P&L per Month'[TIME]))-CALCULATE(SUM('Unrealized P&L per Month'[Unrealized P&L €]),PARALLELPERIOD('Unrealized P&L per Month'[TIME].[Date],-1,MONTH))

.

After that, I use a new dax to take a new table with the below: 

Monthly Figures Unrealized 2 = SUMMARIZE('Unrealized P&L per Month','Unrealized P&L per Month'[MT4 ID],'Unrealized P&L per Month'[TIME],"Position ID",0,"Symbol","Other","Comment**","Other","P&L €",'Unrealized P&L per Month'[P&L €],"Commission €",0,"Swaps €",0,"Volume $",0,"Deposits €",0,"Withdrawals €",0,"Net Credits €",0)

The new table's figures are different. Doesn't working the measure after the use of summarize dax? How can I overcome this? 

Any ideas are welcome. 

Thank you guys and have a great new year. 

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may take a good look at the Remarks and Articles.

[Greg_Deckler]

Am I crazy or are both sets of figures identical? Which one is different??

[Anonymous]

Total P&L € in first table is 25.75m while in second table, total P&L € is -36.36m.

[v-chuncz-msft]

@Anonymous,

Use SUMMARIZECOLUMNS instead.