cancel
Showing results for
Did you mean:
Frequent 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

Proud to be a Datanaut!

Community Support Team

## Re: Calculate formula

```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.