cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Issues using measure in a summarize

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Issues using measure in a summarize

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User

## Re: Issues using measure in a summarize

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

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Community Support Team

## Re: Issues using measure in a summarize

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor

## Re: Issues using measure in a summarize

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

Community Support Team

## Re: Issues using measure in a summarize

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

#### Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)