Calculate formula

[RanjanThammaiah]

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

[v-frfei-msft]

Hi @RanjanThammaiah ,

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

[v-frfei-msft]

Hi @RanjanThammaiah ,

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

Regards,
Frank

[Greg_Deckler]

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