Percent Calculation by row

[Anonymous]

I have a list of projects with total revenue and percent incremental revenue and percent replacement revenue. I can't seem to get my formula to work. I would want it to say:

Incremental Revenue =

IF percent incremental (of that rows Project ID) + percent replacement (of that rows Project ID) = 1,

Amount (of that rows Project ID) * Percent Incremental (of that rows Project ID),

0

Replacement Revenue = 

IF percent incremental (of that rows Project ID) + percent replacement (of that rows Project ID) = 1,

Amount (of that rows Project ID) * Percent Replacement (of that rows Project ID),

Amount

*all revenue is replacement if percent incremental + percent replacement does not equal 1

[v-easonf-msft]

Hi, @Anonymous 

Glad to hear that you have worked it out.

If you have any other questions, please feel free to post for help.

Best Regards,
Community Support Team _ Eason

[Anonymous · Accepted solution]

Ok - so don't know if this was my EASIEST way to get there - so always looking for ways to clean this up. But here's what I came up with:

Incremental Revenue = row("Amount", SUM(AllocatedProjectRevenue[Amount]))*row("Percent Incremental", MAX(AllocatedProjectRevenue[Percent Incremental ]))

Replacement Revenue =

IF (

ISBLANK (

ROW ( "Amount", SUM ( AllocatedProjectRevenue[Amount] ) )

* ROW (

"Percent Replacement", MAX ( AllocatedProjectRevenue[Percent Replacement ] )

)

),

ROW ( "Amount", SUM ( AllocatedProjectRevenue[Amount] ) ),

ROW ( "Amount", SUM ( AllocatedProjectRevenue[Amount] ) )

* ROW (

"Percent Replacement", MAX ( AllocatedProjectRevenue[Percent Replacement ] )

)

)

Revenue Type Dynamic =

IF (

SELECTEDVALUE ( 'Select Revenue Type'[Revenue Type] ) = "Incremental",

[Incremental Revenue],

IF (

SELECTEDVALUE ( 'Select Revenue Type'[Revenue Type] ) = "Replacement",

[Replacement Revenue],

[Incremental Revenue] + [Replacement Revenue]

)

)