cancel
Showing results for
Did you mean:
Regular Visitor

## Calculate formula

Hi All,

Can any one help me to calculate the below formual. I need to divide the Growth %/ Revenue plan Growth %.

These two have been calculated different measure in power BI.

now i have to arrive the Variance by Dividing the below formula.(Growth% / Rev Plan Gr%)

Growth % = DIVIDE(CALCULATE(SUM('Cross Domain'[MTD_TER])-SUM('Cross Domain'[PMTD_TER])),SUM('Cross Domain'[PMTD_TER]),0)

Rev Plan Gr% = DIVIDE(CALCULATE(SUM('Cross Domain'[Revenue_Plan])-SUM('Cross Domain'[PFY_TER])),SUM('Cross Domain'[PFY_TER]),0)

Thanks,
Ranjan
3 REPLIES 3
Super User

## Re: Calculate formula

Sample data and output would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Highlighted
Community Support Team

## Re: Calculate formula

Please try to use the formula. If it doesn't meet your requirement, kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.

```Measure =
VAR Growth =
DIVIDE (
CALCULATE ( SUM ( 'Cross Domain'[MTD_TER] ) - SUM ( 'Cross Domain'[PMTD_TER] ) ),
SUM ( 'Cross Domain'[PMTD_TER] ),
0
)
VAR Rev =
DIVIDE (
CALCULATE (
SUM ( 'Cross Domain'[Revenue_Plan] ) - SUM ( 'Cross Domain'[PFY_TER] )
),
SUM ( 'Cross Domain'[PFY_TER] ),
0
)
RETURN
Growth / Rev
```

Regards,

Frank

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

## Re: Calculate formula

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

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