Forum Discussion

redg's avatar
redg
New Member
4 years ago
Solved

Calculating PV as a Measure

This is my first post on literally any user group, so go easy on me 🙂   I am building a dashboard that calculates PV for a group of accounts.  I'm attempting to leverage What-If parameters to allo...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi redg ,

    Please refer to the pbix file to see if it helps you.

    Modify the measure.

    gross_funding_am_sum =
VAR _b =
    SUMMARIZE ( 'Sheet1', Sheet1[account_id], "aaa", [gross_funding_am] )
RETURN
    IF ( ISINSCOPE ( Sheet1[account_id] ), [gross_funding_am], SUMX ( _b, [aaa] ) )

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi redg ,

Please refer to the pbix file to see if it helps you.

Modify the measure.

gross_funding_am_sum =
VAR _b =
    SUMMARIZE ( 'Sheet1', Sheet1[account_id], "aaa", [gross_funding_am] )
RETURN
    IF ( ISINSCOPE ( Sheet1[account_id] ), [gross_funding_am], SUMX ( _b, [aaa] ) )

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

redg's avatar
redg
New Member
4 years ago

This was it Anonymous !!  Thanks so much 🙂