cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lnz Frequent Visitor
Frequent Visitor

SUMX with measures expression for categories by date

Hi, guys

To calculate stocks portfolio yield dynamic I need to calculate my [Potfolio Total Value] for allselected stocks by date

 

I've made next measures:

  • [Asset Trade Price]
  • [Asset Trade Yield]
  • [Asset Current Amount]
  • [dev Asset Current Price] - I think this measure need some changes
  • [Asset Current Value] = [Asset Current Amount] * [dev Asset Current Price]
  • [Total Current Amount] - Total amount of shares in portfolio
  • [dev Portfolio Current Value] - Total value of portfolio

  

[dev Portfolio Current Value] code:

 

dev Portfolio Current Value = 
VAR d = MAX('calendar'[Date])
RETURN
    CALCULATE(
        SUMX(VALUES('split'[asset-id]);
           [Asset Current Value]
        );
        FILTER(
            ALL('calendar');
            'calendar'[Date] <= d
        )
    )

  

I expect to recive [dev Portfolio Current Value] = 206 359,50 at 16.11.2018 (16th November 2018)
But I've got 222 559,50 because [Asset Current Price] = 193,53 both for Apple and Facebook

 

How could I fix my formulas to sum [amount]*[price] for each asset-id per day

 

PBI Project Here

 

PBI.Community.Topic-0301.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: SUMX with measures expression for categories by date

@lnz,

 

Change it as follows.

VALUES ( company[ticker] )
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.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: SUMX with measures expression for categories by date

@lnz,

 

Change it as follows.

VALUES ( company[ticker] )
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.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 150 members 1,670 guests
Please welcome our newest community members: